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 are actual parameters and formal parameters?
Why do we need unique key in a table?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
How do I install microsoft sql?
What is set serveroutput on in pl sql?
How do I remove all records from a table?
what are the features and advantages of object-oriented programming? : Sql dba
What is sqlexception in java?
what are rollup and cube in t-sql? : Transact sql
What are all ddl commands?
what are the advantages and disadvantages of views in a database? : Sql dba
How does an execution block start and end in pl sql?
Why should I use postgresql?
Which is better stored procedure or query?
What is difference between joins and union?
