Re: what is the dafault percent value of the buffer cache in the SGA.?

In article <1UKE5.22$0T2.1551870_at_nr1.ottawa.istar.net>,   "Zhenming" <zmwang_at_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.