Wat is SGA ?




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



More SQL PLSQL Interview Questions

Which command is used to delete a package?

0 Answers  


What is nvl?

0 Answers  


What is the difference between an inner and outer join?

0 Answers  


What are transaction and its controls?

0 Answers  


Determine if oracle date is on a weekend?

0 Answers  






Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

0 Answers  


explain normalization concept? : Sql dba

0 Answers  


How insert into statements in sql?

0 Answers  


What is error ora-12154: tns:could not resolve the connect identifier specified?

0 Answers  


If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  


Explain autonomous transaction.

0 Answers  


How can you create Cursor with parametres ?

3 Answers  






Categories