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 >