Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Buffer cache statistics (ratios) and CBO SQL optimization?
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...Received on Mon Dec 29 2003 - 20:05:59 CST
> well they do until you saturate it (30 mins after boot :( ).
>