Sapna Malik
What is SGA?
By Sapna Malik in Databases & DBA on Mar 28 2011
  • Sapna Malik
    Mar, 2011 29

    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.

    • 0
  • Sapna Malik
    Mar, 2011 29

    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.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS