Oracle Database Architecture | Oracle Instance

Oracle Database Architecture consists of following three main structures

1- Storage Structure

2- Memory Structure

3- Process Structure

Two of these constitute in primary storage and one in secondary storage.

When a database is created, database files are installed on secondary storage. These files include Control files, Data files, online redo log files, parameter file and password file. All these files formulate “Storage Structure”. Continue reading “Oracle Database Architecture | Oracle Instance”