How is the SGA in an ASM instance made up

An ASM instance has its own SGA but it is not the same as the SGA in a database instance.

The 4 main sections of the SGA in an ASM instance are:

  • ASM Cache – this is used during rebalancing operations for reding and writing blocks.
  • Large Pool – Used for Parallel Operations.
  • Shared Pool – Stored Metadata information.
  • Free Memory – Memory that is not currently allocated.
Categories: Oracle Basics, Oracle RAC Tags: Tags: ,