Re: SGA sizing in Very Large Memory 6 GB

Look at the default INIT.ORA in %ORACLE_HOME%\database. It will show you some sample sizes for a "small", a "medium" and a "large" database. But keep in mind that any of these values are just a starting point, and pretty much no different than a starting point that others can give you as well. The best values will be determined by your application and data access patterns. So you'll have to monitor your performance metrics and adjust accordingly.

HTH,
Brian

Wade Chy wrote:
>
> Hi All,
> I am configuring a new Oracle 9.2 server for a Windows 2003. This
> server has 6 GB available memory. I have not worked with VLM before.
> This is a multipurpose database with approximately 20 GB data in it.
> What will the good values for SGA components like
>
> large_pool_size
> java_pool_size
> db_block_buffers
> etc.
> If any body can email me a copy of a sample parameter file with large
> SGA configuration, I would really appreciate it. Also any
> documentation for 4GB RAM TUNING will highly appreciated. Thanx in
> advance.

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"