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: Tue, 30 Dec 2003 13:05:59 +1100
Message-ID: <3ff0ddb7$1$18746$afc38c87@news.optusnet.com.au>


Not really. Like memory, data also has
what is called a "working set". A set
of data that gets hit all the time.
That's why we have data caches, cache buffers and such. Otherwise, they'd ALL be useless after 30 minutes.

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message
news:3ff07919$0$25673$cc9e4d1f_at_news.dial.pipex.com...

> well they do until you saturate it (30 mins after boot :( ).
>
Received on Mon Dec 29 2003 - 20:05:59 CST

Original text of this message

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