Oracle Architectural Components(英文版)(ppt 31页)
所属分类:Oracle
文件大小:369 KB
下载要求:10 学币或VIP
点击下载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
..............................
下一篇:Oracle RAC体系结构与优势(doc 20页)
Oracle10g数据库管理应用开发标准教程习题(doc 19页)
精品资料网 m.cnshu.cn
Copyright © 2004- 粤ICP备10098620号-1