Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance difference between 2 machines

Re: Performance difference between 2 machines

From: Etunimi Sukunimi <etunimi.sukunimi_at_sonera.com>
Date: Mon, 20 Jun 2005 10:12:43 GMT
Message-ID: <vEwte.87$%h7.23@read3.inet.fi>

sybrandb_at_yahoo.com wrote:
> 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
>

Dang!

I wonder why the dba didn't know this...

Thanks!

The only way to rectify this is to a full export - create a new database - full import, right?

G: Mikael Received on Mon Jun 20 2005 - 05:12:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US