Hello,
My DB is 11.2.0.3, Linux Redhat 6.
I am trying to increase SGA_TARGET to 20G and PGA_AGGREGATE_TARGET to 6G, but my alter system hang.
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 22G
sga_target big integer 17344M
SQL> alter system set sga_target=20G scope=BOTH; => This hangs
SQL> alter system set PGA_AGGREGATE_TARGET=6G scope=BOTH; => This hangs
I believe I can increase the SGA_TARGET without restart as sga_max_size is set to 22G. That's why I didn't included (scope=spfile).
Scope=Spfile works fine. but it is production and I don't want to restart it ...