Oracle Database Developer Question:

Download Job Interview Questions and Answers PDF

Explain System Global Area (SGA) in Oracle?

Oracle Database Developer Interview Question
Oracle Database Developer Interview Question

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.

Download Oracle Database Developer Interview Questions And Answers PDF

Previous QuestionNext Question
Explain Initialization Parameter File in Oracle?Explain Program Global Area (PGA) in Oracle?