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
ORA-27137: unable to allocate large pages to create a shared memory segment Tried to startup a database to NOMOUNT, but failed. SQL> startup nomount; ORA-27137:… Read More »How to Resolve ORA-27137 Error Message
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