Fixed SGA

The Fixed SGA (System Global Area) is a predefined memory area within the Oracle database that serves essential housekeeping functions

  • Purpose: The Fixed SGA contains critical information necessary for the operation and management of the database instance.
  • Contents: General information about the state of the database and the instance, accessible to background processes, Communication details between processes, including information about locks.
  • Size: The size of the Fixed SGA is determined by Oracle Database and cannot be manually altered. It may change with different database releases.
admin

Welcome to the DBA Discovery Hub! As an OCP, I’m here to share articles, tutorials, and tips on Oracle Database Administration. Let’s connect and explore together! Start exploring!

View All Post

One thought on “Fixed SGA”

  1. Pingback: Oracle Database Memory Architecture – DBA Discovery

Leave a Reply

Your email address will not be published. Required fields are marked *