What is variable size when showing SGA?

Variable portion
The 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.
  • Interview Candidate
  • 2
  • 5401

Showing Answers 1 - 2 of 2 Answers

dheeraj narula

  • Dec 27th, 2008
 

Dynamic SGA allows Oracle to set, at run time, limits on how much virtual memory
Oracle uses for the SGA.

So under dynamic(variable ) SGA portion, in intialization parameter file the parameter
SGA_MAX_SIZE is set i.e. the size of variable SGA can be max upto the limit defined in this parameter.

It can be checked by writing   

Select * from v$parameter where name ='sga_max_size';


Please correct me if i am wrong at all.

  Was this answer useful?  Yes

sairavi.dba

  • Jan 31st, 2009
 

In SGA, variable size is combination of shared pool, Java pool and Large Pool

SQL> show sga;

Total System Global Area  612368384 bytes
Fixed Size                  1250428 bytes
Variable Size             171969412 bytes (shardpool+java pool + large pool)
Database Buffers          432013312 bytes
Redo Buffers                7135232 bytes

but java pool and large pool are optional one.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions