Oracle/Windows question 2005-08-12 - By Sweetser, Joe
> > 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
SQL>
--
http://www.freelists.org/webpage/oracle-l
|
|
