What is SGA ?

The  System Global Area (SGA) is a shared memory region allocated by ORACLE that contains data and control information for one ORACLE instance.
  • Interview Candidate
  • 6
  • 2391

Showing Answers 1 - 6 of 6 Answers

Mohammed Abdul Afroze

  • Oct 5th, 2007
 

It is a shared memory region allocated by oracle that contains data and control information for an Oracle Instance. An SGA compromises of Buffer Cache, Redo Log Buffers and Shared Pool Area.

  Was this answer useful?  Yes

subhash.terdale

  • Oct 1st, 2008
 

System Global Area (SGA) is component of instance which consist shared memory & control information of the instance
It consist of shared pool, database buffer cached, redo log buffer, large pool, Java pool.

  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.