Oracle Architectural Components(英文版)(ppt 31頁)

Oracle Architectural Components(英文版)內容提要：
Processing a Query：
Parse:
Search for identical statement
Check syntax, object names, and privileges
Lock objects used during parse
Create and store execution plan
Execute: Identify rows selected
Fetch: Return rows to user process
Redo Log Buffer：
Has its size defined by LOG_BUFFER
Records changes made through the instance
Is used sequentially
Is a circular buffer
Other Instance Processes：
Other required processes:
Database Writer (DBW0)
Process Monitor (PMON)
System Monitor (SMON)
Checkpoint (CKPT)
The archive process (ARC0) is usually createdin a production database

..............................