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

Oracle instance architecture

What is the difference between Oracle architecture and Oracle instance architecture?

Can you please tell me about Oracle instance architecture? What is the difference between Oracle architecture and Oracle instance architecture?
The Oracle instance is comprised of the memory structures and server processes running on the server. When you shut down the instance, no one can access data in the database.

The Oracle database is comprised of the physical files on disk. When the instance terminates, it is these files that make your data persist across shutdowns.

Normally, only one instance can attach to one database. If you are running Oracle's Real Application Clusters, multiple instances can attach to one database for high performance and high availability.

These concepts are discussed fully in the Oracle Concepts Guide. Please go to http://tahiti.oracle.com and click on your Oracle version. Then read the Oracle Concepts Guide for more information.

Dig Deeper on Oracle database design and architecture

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close