Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index clustering factor
dyou98_at_aol.com (D.Y.) wrote in message news:<f369a0eb.0206200843.5680d099_at_posting.google.com>...
> versa. As far as
> performance, I normally don't see a big improvement by tuning
> clustering factor, not
> more than a few percent. It could be because we have so much cache
> these days. You could
Have you done any test on a table that is scanned by parallel slaves, in which case Oracle buffer cache is allegedly bypassed? If that test still doesn't show difference, make sure you enabled filesystem direct I/O or used raw disks and test again.
Yong Huang Received on Thu Jun 20 2002 - 23:18:08 CDT