Database architecture Components

1. Oracle's important position and extensive application in the company. 2. In the Oracle overview, the role of root is emphasized, that is, the overall Oracle architecture. If you have mastered it, you can master 40% of Oracle knowledge. 3. If the static file is not started in the database, it is the file of the operating system. After the static file is started, it is the database process. 4. Dynamic files, mainly in the SGA shared area and

1. Oracle's important position and extensive application in the company. 2. In the Oracle overview, the role of root is emphasized, that is, the overall Oracle architecture. If you have mastered it, you can master 40% of Oracle knowledge. 3. If the static file is not started in the database, it is the file of the operating system. After the static file is started, it is the database process. 4. Dynamic files, mainly in the SGA shared area and

1. Oracle's important position and extensive application in the company.

2. In the Oracle overview, the role of root is emphasized, that is, the overall Oracle architecture. If you have mastered it, you can master 40% of Oracle knowledge.

3. If the static file is not started in the database, it is the file of the operating system. After the static file is started, it is the database process.

4. Dynamic files are mainly the SGA shared area and some core processes.

5. the User process is mainly the client, while the Server process is mainly the Server process. The PGA of the Server process is not from the shared memory.

6. database files (static files) are mainly Configuration Parameter files, superuser files, data files, control files, and log files.

7. database instances (dynamic files) are mainly used to access the database, including the memory structure and background processes.

8. There are three ways to connect to the database instance, including 1) direct connection between the User and the Server on the same machine; 2) network connection between the User and the Server; 3) the browser and User are connected over the network, and the User and Server are also connected over the network, while the User is on the intermediate application Server layer.

9. The role of the Shared Pool in SGA is mainly: 1) Library cache (Database buffer) is mainly used to cache SQL statements, and 2) Data dictionary cache (Data dictionary Buffer) it is mainly used to cache tables and so on. The above two methods are used to improve the efficiency of database operations.

10. The function of the Data buffer cache in SGA is mainly used to cache blocks that are frequently used recently.

11. The PGA (Program Global Area) of the Server process is non-shared and can only be written by the Server process. The memory includes the sorting Area, Session information, and cursor status.