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)将重做日志文件复制到指定的存储设备。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值