Re: Buffer cache hit very low...!!!

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 14 Sep 2005 16:15:54 +0100
Message-ID: <7765c89705091408153582aa88@mail.gmail.com>

On 9/14/05, Michael McMullen <ganstadba_at_hotmail.com> 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

1 row selected.

SQL> show sga

Total System Global Area 1496394596 bytes Fixed Size 457572 bytes
Variable Size 494927872 bytes
Database Buffers 998244352 bytes
Redo Buffers 2764800 bytes

 running on windows SE. Admittedly the buffer cache is rather larger than 250mb

-- 


> Niall Litchfield

> Oracle DBA

> http://www.niall.litchfield.dial.pipex.com


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 14 2005 - 11:04:03 CDT