Oracle Architectural Components(英文版)(ppt 31页)
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
..............................
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热门资料
Oracle相关下载
- Oracle SQL基础培训(ppt 93页)
- Oracle数据库管理--创建数据库
- Oracle Architectural Compone
- Oracle培训教材之总帐管理(ppt
- oracle电子商务套件特别版概述
- Oracle企业管理器概论(PPT 44页
- Oracle经典自学笔记(doc 34页)
- Oracle总帐管理系统讲解(ppt 1
- 试谈Oracle XML DB简化 XML管理
- Oracle顾问实施方法(ppt 30页)
- 论手动部署OA库之Oracle版(doc
- Oracle中型企业商务智能(pdf 3
- Oracle11i总帐管理系统(ppt 17
- 初识Oracle 11g(ppt 32页)
- Oracle数据库管理系统教材(PPT