|
 |
|
Oracle hidden memory manager PGA
advice parameters
Don Burleson
|
Note: Oracle hidden parameters are undocumented
and unsupported by Oracle.
Make sure that you thoroughly test all hidden parameters before
placing them in your production environment.
Parameter Name Description
----------------------------------------- ----------------------------------------------------------------
_smm_advice_enabled if TRUE, enable v$pga_advice
_smm_advice_log_size overwrites default size of the PGA advice workarea history log
_smm_auto_cost_enabled if TRUE, use the AUTO size policy cost functions
_smm_auto_max_io_size Maximum IO size (in KB) used by sort/hash-join in auto mode
_smm_auto_min_io_size Minimum IO size (in KB) used by sort/hash-join in auto mode
_smm_bound overwrites memory manager automatically computed bound
_smm_control provides controls on the memory manager
_smm_max_size maximum work area size in auto mode (serial)
_smm_min_size minimum work area size in auto mode
_smm_px_max_size maximum work area size in auto mode (global)
_smm_trace Turn on/off tracing for SQL memory manager
|
