Two parts of the Oracle Database System

This article describes the architecture of the Oracle database system. We all know that the Oracle database system is a very complex system. In fact, the architecture of Oracle is the relationship between the management components of Oracle databases and these components. The following is an introduction to the text.

Including the memory structure, background process, physical and logical structure, etc.

The Oracle database system is complex because it maximizes memory savings. It is divided into two parts: instance and database file.

I. Instance)

Refers to the memory and related processing programs of the database server. It is the heart of Oracle. The most important relationship with Oracle performance is SGA (System Global Area, which is the active shared memory Area in the System Global Area). SGA includes three parts:

1. Data Buffer to avoid repeated reading of common data;

2. The log buffer increases the speed of adding, deleting, and modifying data, and reduces disk read/write speed;

3. Share the pool to stop compiling the same SQL statement, improving the SQL Execution speed.

2. database files are composed of various file groups in the operating system

1. Logical Structure of the Oracle database:

1) The tablespace, the basic logical structure of the database, is a collection of data files;

2) segments, the space occupied by different types of data in the database, which is composed of multiple zones;

3). The purpose of a zone is to reserve a large space for data at a time;

4). The minimum storage unit, which is specified when the database is created.

2. Physical Structure of Oracle Database:

1). Data File: The File that stores Data;

2) Redo Log File (Redo Log File), which records the processing status of any data in the database and can be used for data recovery;

3) Control File: controls and records the object structure of the database;

4) initialize the Parameter File and configure the memory space;

5). Password File to authenticate the user's permission to start and close Oracle routines.

The above content is an introduction to the relevant content of the Oracle database. I hope you will have some gains.

1. Procedure
2. Oracle cross-server operations
3. Procedure for configuring and installing the Oracle client
4. Two related procedures are required for Oracle import.
5. Brief Analysis of Oracle database architecture