What is SGA?
Sapna Malik
The SGA means 'shared global area' or 'system global area' in a Oracle database is the area in memory to facilitate the transfer of information between users.. This is the shared memory that's allocated from the O/S at instance startup. It is SHARED. It holds the most recently requested structural information about the database. The structure is database buffers, dictionary cache, redo log buffer and shared pool area.