Q

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.

This was first published in September 2006

Dig deeper on Oracle DBA jobs, training and certification

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close