A very large SGA for a VLDB?

From: Daniel B. Bikle <dbikle_at_alumni.caltech.edu>
Date: 19 May 1994 21:54:50 GMT
Message-ID: <2rgn7a$f7_at_gap.cco.caltech.edu>

Hi There,

I've been appointed DBA of an Oracle7 50Gb database running under Solaris 2.3.

I'm tempted to create a buffer pool of 750Mb once we get 1Gb of ram.

But I'm curious; will an extremely large buffer pool help me when doing selects from a 10Gb table?

Is there a point at which getting blocks from disk is quicker than getting them from a very large buffer pool?

Could that point be a buffer pool of 100Mb?

-Dan

---

Daniel B. Bikle
Independent Oracle Consultant
dbikle_at_alumni.caltech.edu
415/854-9542
P.O. BOX 'D'
MENLO PARK CA 94026

---

Received on Thu May 19 1994 - 23:54:50 CEST