Oracle 11g Learning Note 2 Architecture of Oracle Database

There are 4 main architectures for Oracle databases:

1. Physical storage structure
2. Logical storage structure
3. Memory structure
4. Process structure

I. Physical storage structure

The Oracle database is physically composed of system files stored on disk, which is the physical storage structure of Oracle.

1.1 Data files

A data file is a file that is stored in the data in the database, usually in the *.dbf format. Includes system data, data dictionary data, index data.

1.2 Control files

It is usually *. The CTL format used to record the physical structure of the data.

1.3 Redo Log files

Redo log files are used to record all the modified information in the database, usually *. Log format.

Second, logical storage structure

The operation of the database involves a logical storage structure. Logical structure is a logical analysis of the composition of the database, the main description of the Oracle database internal data organization and management methods, independent of the operating system.

The logical storage structure mainly includes: Table space, segment, area and data block.

2.1 Table Space

　　

Oracle 11g Learning Note 2 Architecture of Oracle Database