What is the difference between a database and Instance? What is the relation between them?

Sharad Jaiswal
Sharad Jaiswal

Posted On: Jan 12, 2019

 

A database is the collection of three basic physical structure and these structures are data files, redo log files and control files which are stored in a disk whereas instance comprises an Oracle background process such as System MOnitor (SMON), Process MOnitor (PMON), Database writer (DBWR), Log WRiter (LGWR) and memory structure such as System Global Area (SGA), Program Global Area (PGA). These Oracle background Processes share a common memory area while running on a computer.

Another important difference between the database and an instance is that an instance is able to install and open only a single database whereas a database can be installed or opened by more than instance with the help of Real Application Cluster (RAC).

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Oracle DBA Interview Questions

    What do you understand by the Oracle?

    Oracle is a database company that stores the data. Oracle stores the data in a very definite way so that client can regain it in a multi-user condition...

    Oracle DBA Interview Questions

    What do you mean by Oracle Database?

    Oracle has the main theme of storing, creating and managing the database...

    Oracle DBA Interview Questions

    What do you mean by Oracle DBA and what is its role?

    DBA stands for the Database administrator. DBA has the proper rights that can add or remove new users...