From: oratune@aol.com
Newsgroups: comp.databases.oracle.server
Subject: Re: what is the dafault percent value of the buffer cache in the SGA.?
Date: Tue, 10 Oct 2000 20:52:33 GMT
Organization: Deja.com - Before you buy.
Lines: 25
Message-ID: <8rvvif$opr$1@nnrp1.deja.com>
References: <1UKE5.22$0T2.1551870@nr1.ottawa.istar.net>
NNTP-Posting-Host: 38.193.42.5
X-Article-Creation-Date: Tue Oct 10 20:52:33 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
X-Http-Proxy: 1.1 x57.deja.com:80 (Squid/1.1.22) for client 38.193.42.5
X-MyDeja-Info: XMYDJUIDddf_dba


In article <1UKE5.22$0T2.1551870@nr1.ottawa.istar.net>,
  "Zhenming" <zmwang@maloca.com> wrote:
> Is there any default value or recommanded value from Oracle for the
 data
> buffer cache in the SGA? One question I met  from an online DBA test
 company
> which many recruiters use to test the applicants. It ass  what is the
> dafault percent value of the buffer cache in the SGA. according to my
> knowledge, Oracle never suggests such a value,
> at least we cannot fine it from its manuals.
>
> Zhenming
>
>

According to Oracle documentation the default value for the
db_block_buffers parameter is 48/db_block_size.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.