Oracle Memory Management Question: Download Questions PDF
What is SGA? How it is different from Ver 6.0 and Ver 7.0?
Answer:
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.
Download Memory Management Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How to implement the multiple control files for an existing database? | What is a Shared SQL pool? |