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