Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

What is an Instance ?

Combination of SGA and background processes together is called as an Instance.
Once the instance is down, we cannot establish the connection to the database and we cannot access the data in the existing database.
In a standalone system a database will have only once instance i.e. 1:1 ratio.

Oracle is popular for database and at the same time it is popular for instance level failures. To overcome this problem, oracle has introduced multi instance databases which are nothing but RAC databases.
Related Posts Plugin for WordPress, Blogger...

Flag Counter