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: Buffer cache statistics (ratios) and CBO SQL optimization?

Re: Buffer cache statistics (ratios) and CBO SQL optimization?

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: Thu, 1 Jan 2004 23:07:05 +1100
Message-ID: <3ff411cf$0$18693$afc38c87@news.optusnet.com.au>


Interesting. Thanks a lot.

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:bsurav$hbs$1$8302bc10_at_news.demon.co.uk...

>
>
> I think there has been a steady increase in the code
> path, so in my test case, the rate has tended to decrease
> with version of Oracle. On the other hand, some SQL
> has gone faster because new strategies have been
> introduced to reduce the number of units of action
> required even though the cost of a single unit may
> have increased.
>
Received on Thu Jan 01 2004 - 06:07:05 CST

Original text of this message

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