Answer Posted / Subhasish Madvel
The System Global Area (SGA) is a memory area shared by all server processes in an Oracle instance. It consists of several components, including:
1. Database Buffer: Caches data blocks from the database.
2. Redo Buffer: Holds redo log entries before they are written to the online redo logs.
3. Shared Pool: Stores shared SQL areas (containing parsed SQL statements), library cache (containing shared libraries), and other data structures.
4. Large Pool: Manages large memory allocations for server processes.
5. Java Pool: Supports the Oracle JVM.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
