RE: Oracle/Windows question
- From: "Sweetser, Joe" <Joe.Sweetser@xxxxxxxxxxxxxxx>
- To: "Leandro Guimaraes Faria C. Dutra" <ldutra@xxxxxxxxxxxxx>
- Date: Fri, 12 Aug 2005 13:41:17 -0700
> > 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>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
