Problem solve Get help with specific problems with your technologies, process and projects.

What is an instance?

What is an instance? Can we open more than one instance in a machine?

What is an instance? Can we open more than one instance in a machine?
Before I define an instance, I should define a "database." In Oracle, a database is a collection of files that reside on the server. These are the datafiles belonging to multiple tablespaces and the online redo logs. When the server is shut down, the data persists in the datafiles.

The instance is the allocated memory and collection of processes running on the server. When you start Oracle, memory is allocated and processes are started which perform the many housekeeping tasks to keep the database healthy. You can turn off the instance and the database will remain. Normally, the instance attaches to one and only one database. You cannot have two instances connected to the same database and you cannot have an instance attach to two databases. However, there is an additional Oracle product called Real Application Clusters (RAC) which does let you have multiple instances attach to one database. RAC is used for high performance and high availability. Each instance runs on a separate server so the load is spread out on more than one machine. And if a server goes down, the other servers (or nodes) can handle the load.

You can have more than one instance running on a server. I often have two, three or four instances running on a server, each attached to their own database. Each instance consumes resources (CPU and physical RAM) on the database server. So make sure you have enough resources to support all of your instances.

Dig Deeper on Oracle DBA jobs, training and certification