Answer Posted / 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 |
Post New Answer View All Answers
What is sql*loader and what is it used for?
What are the different datatypes available in PL/SQL?
What is sql integrity?
What is a trigger word?
What is trigger point?
what is a tablespace? : Sql dba
How can you tell the difference between an index and a view?
What operators deal with null?
What is sql stand for?
Which table is left in join?
What is the difference between partition and index?
Explain table and field in sql?
what is uncommittable transactions? : Transact sql
Advantages and disadvantages of stored procedure?
How can a pl sql block be executed?
