Re: Performance difference between 2 machines

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Mon, 20 Jun 2005 23:33:07 +0200
Message-ID: <42b73613$0$24269$ba620e4c@news.skynet.be>

<sybrandb_at_yahoo.com> wrote in message
news:1119255391.716548.104290_at_g49g2000cwa.googlegroups.com...
> The obvious cause is the difference in database block size.
> Ct shouldn't have set it to 16k. Means one physical I/O executed by
> Oracle, will result in *2* physical I/Os on O/S level. Those two I/Os
> will suffer from rotational delay by the disks (ie, the second 16K will
> be read not immediately after the first).
> IMO, setting the database block size bigger than the O/S block size
> will result in massive delays... which is what we are seeing here.
>
>
> Hth
> ---
> Sybrand Bakker
> Senior Oracle DBA
>

Sybrand, related question : we are using AIX 5.2 64-bit with jfs2 filesystems, data on EMC Symmetrix. What would be the recommended database block size ? And do we need a smaller block size for OLTP than for DWH databases ?

Matthias Received on Mon Jun 20 2005 - 16:33:07 CDT