Posted On: Feb 22, 2018
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).
Never Miss an Articles from us.
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 has the main theme of storing, creating and managing the database...
DBA stands for the Database administrator. DBA has the proper rights that can add or remove new users...