관련 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