What is an Oracle server 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 server instance?
Rating:
An Oracle server instance is a collective term used for Oracle server memory structures. An Oracle server instance consists of Oracle's main memory structures, System Global Area (SGA) and Oracle background processes. The components of an instance are used for efficiently managing data in the database and serving the user requests of the associated database. Single or multiple instances can exist concurrently for a single database. Multiple instances with each instance having access to its own database can also exist on a computer.
Rating:
Was this information helpful?
Other articles
- What is user global area (UGA)?
- What is a transaction table?
- What is pinning?
- What is Program Global Area (PGA)?
- What is the function of AUTOTRACE utility?