Variable portionThe variable portion is called variable because its size (measured in bytes) can be changed. The variable portion consists of: • large pool (optional)Provides working space for rman (although rman will also work without large pool). • Shared pool The shared pool is used for objects that are shared among all users. For example: table definitions, PL/SQL definitions, cursors and so on.

sairavi.dba

 Profile Answers by sairavi.dba Questions by sairavi.dba

• Jan 31st, 2009

In SGA, variable size is combination of shared pool, Java pool and Large PoolSQL> show sga;Total System Global Area  612368384 bytesFixed Size        &n...

dheeraj narula

 Profile Answers by dheeraj narula Questions by dheeraj narula

• Dec 27th, 2008

Dynamic SGA allows Oracle to set, at run time, limits on how much virtual memoryOracle uses for the SGA.So under dynamic(variable ) SGA portion, in intialization parameter file the parameterSGA_MAX_SI...

Answer Question  Select Best Answer