Oracle study notes - know

xiaoxiao2021-03-06  57

Start Oracle's Adventure Today.

Windows installation:

Oralce Server can only be installed on a server operating system, and the client can be installed on the client operating system.

Oracle Server Windows 2000 Server

Oracle Client Windows 2000 Personal Edition

Oracle client includes running, self-contained development tools, management tools, SQL * Plus, etc.

2. The relationship between two working modes and Oarcle Console login method:

C / S (two layers) start standing

Web distribution (three layers) log in to Oarcle Management Server

3. Two types of processes

User Process Processing SQL Plus, Enterprise Manager Request

10 types of processes running in the background of the server process

4. Two memory global districts

System Global Zone (SGA) is shared by all user processes in database server.

The Program Hide Area (PGA) is assigned to the user process for the user process, which is similar to the user process. It cannot be shared.

5. Six-layer logical structure

database

Table space TableSpace (9 typespaces)

Logic objects (table, view, index)

Data segment segment (data segment, index section, temporary section, rollback)

Data section extent

Data block block

Main tablespace introduction:

System Table Space (SYSTEM)

The tablespace contains data files, called system data files, is used to store system tables and data dictionaries, and a large number of reading is a significant feature of the table space.

Temporal Table Space (Temporary) The tablespace includes temporary data files, such as temporary data files. After the system is restarted, the table space is emptied.

Rollback Segment Table Space (ROLLBACK) If the database is modified to the data, you must use the rollback segment, and the rollback segment is used to hold the data (Undo) before the modification. Rollback segments are usually placed on a separate table space (rollback table space), avoid watch space fragmentation, which contains data files that are rollback data files. Rollback segments are a lot of writing, a small number of reads.

User Table Space (USER) is included as user data file, typically established by the user to access tablespaces of user data, generally two types of common user data, data, and indexes.

Compared with other databases, it is indeed more complicated, I want to be because of this, the function of OARCLE is not comparable.

Three-layer physical structure

database

Storage file (data file .dbf, control file .ctl, log file .log)

Physical block

6 files

Data file (.dbf): Store all data;

Control file (.ctl): Record control information for all files in the database

Log file (.log): Records all the operations in the database

转载请注明原文地址:https://www.9cbs.com/read-117914.html

New Post(0)