Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How can I further reduce physical read for this query short of throwing memory at it?

Re: How can I further reduce physical read for this query short of throwing memory at it?

From: Joel Garry <joel-garry_at_home.com>
Date: 14 Feb 2006 13:14:40 -0800
Message-ID: <1139951680.683817.241840@z14g2000cwz.googlegroups.com>

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.html
Received on Tue Feb 14 2006 - 15:14:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US