Shared Pool

How to Resolve ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated

by Ed Chen
July 21, 2021March 17, 2022

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-04031: unable to allocate 4216 bytes of shared memory

by Ed Chen
September 3, 2014December 11, 2022
2 Comments

Causes of ORA-04031 Found ORA-04031 in the alert log. ORA-04031: unable to allocate 4216 bytes of shared memory ("shared pool","unknown object","sga heap","library cache") Several kinds… Read More »

How to Check Free Memory in SGA Pools

by Ed Chen
October 29, 2012March 28, 2018

The dynamic view gv$sga can tell you how much memory he occupied from OS. They won't change very often. The real available memory of SGA… Read More »

How to Check SGA Components Memory Distribution on Database 9i

by Ed Chen
October 28, 2012May 13, 2019

SGA Components For database 9i, there is no dynamic view gv$sgainfo like 10g or 11g that can represent current memory distribution of every component. Another… Read More »