SGA is shared location for oracle database instance. This memory will be shared or used by multiple processes running in that instance. This shared location is divided into multiple areas and each area will be used for different purpose.
Here are those areas,
1. Large pool:-
This holds information about UGA (User Global Area). This holds information related with user sessions.
2. dictionary cache:-
It holds information about data dictionary.
3. Java pool:-
It will be used for parsing java statements.
4. Shared pool:-
It holds information about commonly used SQL statements.
5. redo buffer:-
It holds info about committed transactions but not yes written to online log.
6. buffer cache:-
Holds data blocks from tables.
Here are those areas,
1. Large pool:-
This holds information about UGA (User Global Area). This holds information related with user sessions.
2. dictionary cache:-
It holds information about data dictionary.
3. Java pool:-
It will be used for parsing java statements.
4. Shared pool:-
It holds information about commonly used SQL statements.
5. redo buffer:-
It holds info about committed transactions but not yes written to online log.
6. buffer cache:-
Holds data blocks from tables.