從Oracle9i開始,Oracle引入了自動PGA治理的新特型,PGA_AGGREGATE_TARGET參數用于控制PGA的總體期望目標: $ sqlplus "/ as sysdba"SQL*Plus: Release 9.2.0.4.0 - PRodUCtion on Thu Apr 6 16:40:13 2006Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production With the Partitioning option JServer Release 9.2.0.4.0 - ProductionSQL> show parameter pgaNAME TYPE VALUE ------------------------------------ ----------- ------------------------------ pga_aggregate_target big integer 1073741824 SQL> 但是在Oracle9i中，PGA_AGGREGATE_TARGET參數僅對專用服務器模式下（Dedicated Server）的專屬連接有效，對共享服務器（Shared Server）連接無效；從Oracle10g開始PGA_AGGREGATE_TARGET對專用服務器連接和共享服務器連接同時生效。原文地址：http://www.eygle.com/archives/2006/04/pga_aggregate_target_changed.Html
