Increase PGA_AGGREGATE_LIMIT Whenever you need more PGA to service clients or saw error ORA-04030, you may consider to raise PGA size online. Let's see current… Read More »Alter System Set PGA_AGGREGATE_LIMIT
Tuning ASSM or ASM target can never be done within SCOPE=MEMORY or even SCOPE=BOTH, which is not allowed. SQL> alter system set sga_target=64g scope=both; alter… Read More »How to Raise SGA_TARGET or MEMORY_TARGET
SGA contains many memory areas:Database Buffer CacheIn-Memory Column StoreRedo Log BufferShared PoolLarge PoolJava PoolStreams PoolFixed SGAThe two major areas are shared pool and large pool… Read More »What Memory Areas are in the Large Pool