Ask the Expert

What is an instance?

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

    Requires Free Membership to View

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.

This was first published in September 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: