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

The largest DB we have on SE is about 20 gig.

We do have 700Gig on Windows 2000, but it is advanced server.

Last week I had 1.2 tb on Windows for some testing.

As for the 40gb database - for some reason I thought it was referring to memory, not database size when I offerred my apologies.

My K/B is going into read-only mode before 08:00. :)

Jared

On 9/14/05, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
> 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
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
11+ years of trying to appear to know what I'm doing.
--
http://www.freelists.org/webpage/oracle-l