RE: Oracle/Windows question

> > If my best immediate solution is to reduce the size of the SGA and I
> > have these values set (I inherited this db so can't address why
values
> > where changed):
>
> > shared_pool_size = 300000000 #previous value: 40000000
> > shared_pool_reserved_size = 3000000 #previous value: 2000000
> > log_buffer = 1048576 #previous value: 163840
>
> > any idea where I might get the most "bang for the buck"?
>
> You must monitor for your specific situation... but the
biggest
>
> influence in SGA is db_cache_size.
>

Researching now, but does this make sense? Manual sez default=48:

SQL> show parameter db_cache_size

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
db_cache_size                        big integer 0

--
http://www.freelists.org/webpage/oracle-l