Database architecture Components

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.