Alter System Set PGA_AGGREGATE_LIMIT
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
Memory
How to Resolve ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated
JDBC ORA-12850 Some developers report ORA-12850 error in their JDBC log. ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated There… Read More »How to Resolve ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated
How to Resolve ORA-01000: maximum open cursors exceeded
ORA-01000 Saw an error ORA-01000 when executing a lot of statements. It seemed that the number of open cursors has reached the limitation. ORA-01000: maximum… Read More »How to Resolve ORA-01000: maximum open cursors exceeded
How to Resolve ORA-27137: unable to allocate large pages to create a shared memory segment
ORA-27137 Tried to startup a database to NOMOUNT, but failed. SQL> startup nomount; ORA-27137: unable to allocate large pages to create a shared memory segment… Read More »How to Resolve ORA-27137: unable to allocate large pages to create a shared memory segment
How to Raise SGA_TARGET or MEMORY_TARGET
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
What is Variable Size SGA
SQL> show sgaTotal System Global Area 6.1189E+10 bytesFixed Size 830456 bytesVariable Size … Read More »What is Variable Size SGA
What Memory Areas are in the Large Pool
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