What are the various ingredients of SGA?

- SGA stands for System Global Area which is helpful to conserve the shared information all over the database users. It comprises of Data Dictionary cache, Library cache, Database Buffer Cache, Shared Pool, Redo log Buffer cache.

• Library Cache - Library cache is employed to deposit statements of Oracle
• Data Dictionary Cache - Data Dictionary Cache comprises of the key of Database objects and rights that are given to users.
• Data Base buffer cache - Data Base buffer cache collects the information regarding the data blocks which are usually accessed. holds copies of data blocks by this, it is easy to regained quickly for the future requests.
• Redo log buffer cache - Redo log buffer cache look after the records of the changes that are made in the data files.