需關閉數據庫實例修改 SPFILE,建議維護窗口操作。
SHOW PARAMETER TARGET;SELECT VALUE FROM V$PGASTAT WHERE NAME = 'maximum PGA allocated';MEMORY_TARGET = SGA_TARGET + MAX(PGA_AGGREGATE_TARGET, MAXIMUM_PGA_ALLOCATED)ALTER SYSTEM SET MEMORY_MAX_TARGET = M SCOPE = SPFILE;
ALTER SYSTEM SET MEMORY_TARGET = M SCOPE = SPFILE;
若用 PFILE 手動編輯:
memory_max_target = M
memory_target = M SHUTDOWN IMMEDIATE; STARTUP;MEMORY_MAX_TARGET 為靜態參數,上限不可動態調大SGA_TARGET、PGA_AGGREGATE_TARGET 成為動態調節下限V$MEMORY_DYNAMIC_COMPONENTS 觀察內存組件自動伸縮