AI智能
改变未来

Oracle体系结构及进程

翻看Oracle官方文档,没有细致做过笔记,有些临时的笔记也都是没有体系化。以下是通过官档按照自己的理解翻译了一些
1、Oracle 11g数据库体系结构图

2、进程架构图(摘自Oracle官方文档)

2.1 DBWn :The database writer process (DBWn) writes the contents of buffers to datafiles.
数据库写进程负责将数据库缓冲的内容(脏buffer)写回数据文件
2.2 LGWR:The log writer process (LGWR) is responsible for redo log buffer management—writing the redo log buffer to a redo log file on disk. LGWR writes all redo entries that have been copied into the buffer since the last time it wrote.
日志写进程负责管理日志缓冲区,将一段连续的日志缓冲区的内容写到日志文件
The log writer process (LGWR) manages the redo log buffer. LGWR writes one
contiguous portion of the buffer to the online redo log;
2.3CKPT
When a checkpoint occurs, Oracle must update the headers of all datafiles to record the details of the checkpoint. This is done by the CKPT process. The CKPT process does not write blocks to disk; DBWn always performs that work.
The checkpoint process (CKPT) updates the control file and data file headers with
checkpoint information and signals DBWn to write blocks to disk;
检查点进程会按照时间先后顺序来更新控制文件和数据文件头部的检查点信息(scn);
还负责驱动DBWn进程去写脏块
2.4 SMON
SMON is also responsible for cleaning up temporary segments that are no longer in use and for coalescing contiguous free extents within dictionary managed tablespaces.
SMON负责清理不再使用的临时段,并在字典管理的表空间中合并连续的空闲区。
2.5 PMON
PMON is responsible for cleaning up the database buffer cache and freeing resources that the user process was using.
PMON负责清理数据库缓冲区缓存并释放用户进程正在使用的资源。
2.6 ARCn
The archiver process (ARCn) copies redo log files to a designated storage device after a log switch has occurred.
在发生日志切换之后,archiver进程(ARCn)将重做日志文件复制到指定的存储设备。

赞(0) 打赏
未经允许不得转载:爱站程序员基地 » Oracle体系结构及进程