Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can I further reduce physical read for this query short of throwing memory at it?
Jining Han wrote:
> Just ran it in a non-RAC 10gR2 database after importing the tables. HW
> is HP-UX PA-RISC, with much smaller SGA configuration, but same EMC SAN
> storage. The trace and plan look very similar, however the response
> time is almost 1/2 . Also, there is no more REDO size in the 10gR2.
See bug 4965967. Are you seeing much more cpu usage in the RAC configuration? Maybe it's not even a bug, just too much pinging.
>
> I can't say with any certainty if 10gR2 is THE reason, but if I
> believe what I read once about improved SORT in R2, then I have one
> more strong reason to upgrade.
>
> Thanks
> JH
jg
-- @home.com is bogus. "We're not a gang, we're a club!" - Cheech & Chong http://www.signonsandiego.com/uniontrib/20060213/news_1n13clubs.htmlReceived on Tue Feb 14 2006 - 15:14:40 CST