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