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: Tue, 21 Jun 2005 06:04:04 GMT
Message-ID: <o5Ote.12$N23.8@read3.inet.fi>

Certainly - that is if I can convince the customer that this needs to be done...

Might take some time, though.

G: Mikael

xhoster_at_gmail.com wrote:

> Etunimi Sukunimi <etunimi.sukunimi_at_sonera.com> wrote:
> 

>>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?
> 
> 
> Can you let us know how it turns out?
> 
> Thanks,
> 
> Xho
> 
Received on Tue Jun 21 2005 - 01:04:04 CDT

Original text of this message

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