Re: Buffer cache hit very low...!!!
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: ganstadba@xxxxxxxxxxx
- Date: Wed, 14 Sep 2005 16:15:54 +0100
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
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
Other related posts:
