Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Interleave factor performance impact
I've seen that book referenced in so many plances that I placed an order on Amazon.
Still, my original question remains unanswered. Given the interleave factor difference, how much impact would that have on memory intensive database queries? Is it negligible or is it a big deal?
Thanks.
hpuxrac wrote:
> eavile..._at_yahoo.com wrote:
> > Hans,
> >
> > The same batch process runs about 50% faster on the test server.
> >
>
> Cary Millsap's book "Optimizing Oracle Performance" contains a proven
> methodology for solving problems like yours. I recommend highly taking
> the time to read this book as the primary way of determining how to
> attack your problem.
>
> You can get 10046 traces for a representative time of the batch run on
> the production server and see what "is slowing it down". Compare and
> contrast this with what you see from the batch run on the test server.
Received on Fri Feb 03 2006 - 22:46:47 CST