Interested to Buy Any Domain ? << Click Here >> for more details...
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
- 1 Answers
- 5069 Views
- TCS, I also Faced
- E-Mail Answers
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 is recovery manager in Oracle?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How to get a list of all background sessions in the database?
What is a nested table?
What is a procedure in oracle?
How to use null as conditions in oracle?
How to change user password in oracle?
How to write text literals in oracle?
Why do we need integrity constraints in a database?
How to export several tables together?
Give syntax for SQL and ORACLE joins.
Explain what does a control file contain?
How to drop a tablespace?
Difference between inner join vs where ?
When do you get a .pll extension in oracle? Explain its importance
