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.