Re: Buffer cache hit very low...!!!
- From: Chirag DBA <chiragdba@xxxxxxxxx>
- To: niall.litchfield@xxxxxxxxx
- Date: Wed, 14 Sep 2005 16:13:17 -0400
Well, As I said to all,
SELECT NAME,100-PHYSICAL_READS/(DB_BLOCK_GETS + CONSISTENT_GETS) FROM
V$BUFFER_POOL_STATISTICS;
the above query was showing 96% cache hit but in OEM it was very low,
need to know hw oracle is calculating that in new OEM. (10g).
and I agree with that the 250mb SGA is very low for 40GB DB. Need to
increase that gradually.
I have prioritize to calling GEICO for now.
regards - Chirag
On 9/14/05, Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote:
>
> On 9/14/05, Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote:
> >
> > On 9/14/05, Michael McMullen < ganstadba@xxxxxxxxxxx> wrote:
> > >
> > > Well, I did ask for platform. And a 40Gb database on windows 2000 SE,
> > > how
> > > many people have those?
> >
> > SQL> select sum(bytes)/1024/1024/1204 SizeGB
> > 2 from dba_data_files;
> >
> > SIZEGB
> > ----------
> > 48.75
> >
>
> Michael kindly pointed out that this isn't the best definition of GB in
> the universe. 1204 not being a fantasticly good number. This is why I
> normally script everything - inability to type.
> --
> Niall Litchfield
> Oracle DBA
> http://www.niall.litchfield.dial.pipex.com
>
Other related posts:
