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