Analysis of Oracle architecture and Memory Allocation Mechanism

Oracle contains three parts:

1: Oracle Server: An Oracle Server. Generally, it can be seen as a machine. We can call it a Server. It can also be seen as a set of software running on the server.

It is defined on the official Oracle website as follows:

An Oracle server is a database management system that provides an open, comperhensive, and integrated approach to information management.

An Oralce server consits of an Oracle instance and an Oracle database;

From the above text, we can see that Oracle server is a large concept of a database management system that provides an open and complex integrated information management system. There are two examples in this section: Instance (Oracle Instance) and Oracle database ).

Figure 1: Oracle Server Diagram

2: Oracle Instance (Oracle Instance)

Definition: A Oracle Instance is means to access an Oracle database)

Alway open one and only one database. Databases can correspond to and Access Multiple instances. In general mode, Oracle instances and Oracledatabase are in a relationship, while in clusters, Oracle instances are in a relationship.

In addition, the Oracle Instance is composed of memory and oracle background processes (see section 2 ).

Figure 2: The structure of Oralce Instance

Connection: the TCP Connection established between the Oracle client and the process.

Server Process: a service Process, mainly used to Process client and background connections.

After the security verification is passed, a Session (session) 3 is created at the Oracle link.

An Oracle database is a collection of data that is threaded as an unit. It. Constists of three file type.

1 2 3 4 Next Page