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.
Start the conversation
0 comments