Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance difference between 2 machines
"Matthias Hoys" <idmwarpzone_NOSPAM__at_yahoo.com> wrote:
>
> But, if I use a (low) block size of 4k, won't I risk ending up with lots
> of chained rows for "wide" tables (and thus double i/o to get those rows)
> ?
But what if you use 8k blocks and then end up doing double i/o to get *every* non-cached row, whether it is chained or not?
Of course in one case the double i/o is at the system level and only has to deal with latches and chains and consistent reads and such once, and in the other it is at the Oracle level and has to deal with latches and chains and consistent reads twice, but still it doesn't sound all that good.
Xho
-- -------------------- http://NewsReader.Com/ -------------------- Usenet Newsgroup Service $9.95/Month 30GBReceived on Mon Jun 20 2005 - 19:07:21 CDT