Basic Oracle Concepts and Programming Question:
What is System Global Area (SGA) in Oracle?
Answer:
The System Global Area (SGA) is a memory area that contains data shared between all database users such as buffer cache and a shared pool of SQL statements. The SGA is allocated in memory when an Oracle database instance is started, and any change in the value will take effect at the next startup.
| Previous Question | Next Question |
| What Is a Initialization Parameter File in Oracle? | What is Program Global Area (PGA) in Oracle? |