🎴 Flashcard Mode
Oracle Practice Test - 14
Card1 / 19
Mastered0
Review0
QuestionClick to flip
When is the SGA created in an Oracle database environment?
AnswerClick to flip back
A
When the instance is started
💡 Explanation:
The System Global Area (SGA) is allocated when the Oracle instance starts up, not when the database is created or mounted. The instance consists of memory structures (SGA) and background processes. Database creation creates physical files, mounting reads the control file, but neither allocates the SGA. User processes connect to an already-running instance with an existing SGA.