Admin

PGA_AGGREGATE_TARGET

Qhtlr 2009. 9. 15. 18:07


관련 Parameter

pga_aggregate_target     = 1073741824
PARAMETER             DESCRIPTION                                                       SESSION_VALUE   INSTANCE_VALUE
-------------------- -------------------------------------------------- ------------------ ------------------
_smm_max_size        maximum work area size in auto mode (serial)                     52428               52428
_smm_px_max_size   maximum work area size in auto mode (global)                   314571              314571
_pga_max_size          Maximum size of the PGA memory for one process         209715200          209715200

V$SQL_WORKAREA
V$SQL_WORKAREA_ACTIVE
V$SQL_WORKAREA_HISTOGRAM
v$pga_target_advice