Memory Management Interview Question:

What is SGA? How it is different from Ver 6.0 and Ver 7.0?

Submitted by: Administrator

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.
Submitted by: Administrator