Re: SGA configuration

On Fri, 2 Sep 2005 09:36:49 +0200, "astalavista" <spam_at_nowhere.com> wrote:

>I would change the other parameters like below:
>Cache = 450M
>Shared Pool= 100M
>Log Buffer = 0.5M
>Large Pool = 130 M ( RMAN is used )
>Java Pool = 50 M ( no Java in database)
>
>And these prarameters are dynamicly modifiable
>( no reboot, this is a production database )
>
>What do you think about that ?

You are shooting in the dark.
First of all you should use v$sgastat to find out how much of that memory is actually used. You can also use v$db_cache_advice to see how much you gain by increasing the buffer cache. You can change these parameters dynamically *provided* you don't use any of the obsolete parameters like db_block_buffers, but have used db_cache_size.
If you use db_block_buffers, rectifying this (and rebooting the database during scheduled downtime) is in order.

--
Sybrand Bakker, Senior Oracle DBA