What is an Oracle instance?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is an Oracle instance?
Rating:
An Oracle instance is a combination of System Global Area (SGA) and Oracle background processes. When a database is started, a memory area, called SGA, is allocated and Oracle background processes are started. The SGA and the Oracle background processes manage the associated database's data and serve the database users. The SGA is de-allocated when the instance is shut down.
Rating:
Was this information helpful?
Other articles
- What is NLS_LANG?
- How is an Oracle database opened?
- What is Spot SQL?
- What is a tablespace?
- What is Transparent Application Failover (TAF)?