Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Buffer cache hit very low...!!!

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

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 14 Sep 2005 08:44:12 -0700
Message-ID: <bf463805091408443859c79b@mail.gmail.com>


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
Received on Wed Sep 14 2005 - 11:16:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US