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

This is a meaningless question - the size of the SGA depends largely on the size of the buffer cache. Indeed, the only thing that is separately defined is the shared pool size.

A better question would be

"What percentage of system RAM should be given over to the SGA for a busy online transaction processing system?"

David Pomphrey OCP MCP B.Tech.

• 0.6 Terabytes and I feel fine ---

  ---

Zhenming 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
Received on Sat Oct 07 2000 - 20:39:42 CDT