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: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 30 Dec 2003 10:08:45 -0000
Message-ID: <3ff14ead$0$13347$ed9e5944@reading.news.pipex.net>


That is true, but how much of that working set is sitting in the SGA anyway? How many cache's does one need in a system?

But you are correct my remark was too flippant, sorry.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK


> 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 Tue Dec 30 2003 - 04:08:45 CST

Original text of this message

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