What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
Answer Posted / sawant
The System Global Area in a Oracle database is the
area in memory to facilitates the transfer of information
between users. It holds the most recently requested
structural information between users. It holds the most
recently requested structural information about the database.
The structure is Database buffers, Dictionary cache, Redo
Log Buffer and Shared SQL pool (ver 7.0 only) area.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What do you mean by merge in oracle and how can we merge two tables?
What are the differences between interval year to month and interval day to second?
types of indexes and the rationale behind choosing a particular index for a situation.
What happens to the indexes if a table is recovered?
What is the Tune Query
How to find the duplicate rows count from employees table in oracle?
What is the difference between substr & instr functions?
How to use attributes of the implicit cursor in oracle?
What are the different types of trigger and explain its various uses and functions?
How to change user password in oracle?
How to create a new oracle data file?
What is an external table?
Calculate difference between 2 date / times in oracle sql?
How to call a sub procedure?
What are the different oracle database objects?