Large Pool

What Memory Areas are in the Large Pool

by Ed Chen
September 4, 2015May 17, 2019

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 »

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 »