Wat is SGA ?

Question Posted / avinash pradhan

3 Answers
5084 Views
ABB, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Wat is SGA ?..

Answer / swapneswar

system global area(SGA) is a shared memory regionallocated
by ORACLE that contains data and control information for
one ORACLE instance

Is This Answer Correct ?

7 Yes

0 No

Wat is SGA ?..

Answer / mohit lalwani

SGA known as System Global Area and is a part of the Oracle instance.

SGA consist of different memory structures which are

-Shared pool (mandatory)
-Database Buffer Cache (mandatory)
-Redo Log Buffer (mandatory)
-Large Pool (optional)
-Java Pool (optional)

-SGA is sized by sga_max_size

Is This Answer Correct ?

2 Yes

0 No

Wat is SGA ?..

Answer / narayan mishra

->SGA stands for System Global Area.
->it store the data and control information for oracle srever.
->it can be shared by database processes.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer