backgroup process

简介: DBWn writes when 1.      Checkpoint 2.      Dirty buffers threshold reached 3.      No free buffers 4.
 

DBWn writes when

1.      Checkpoint

2.      Dirty buffers threshold reached

3.      No free buffers

4.      Timeout

5.      RAC ping request

6.      Tablespace offline

7.      Tablespace read only

8.      Table DROP or TRUNCATE

9.      Tablespace BEGIN BACKUP

 

GLWR writes when

1.      At commit

2.      When one-third full

3.      When there is 1MB of redo

4.      Every 3 seconds

5.      Before DBWn writes

 

SMON Responsibilites

1.      instance recovery:A.Rolls forward changes in the redo logs;B.Opens the database or user access;C.Rolls back uncommitted transactions

2.      Coalesces free space ever 3 sec

3.      Deallocates temporary segments

 

PMON

Cleans up after failed processes by

A.     Rolling back the transaction

B.     Releasing locks

C.     Releasing other resources

D.     Restarts dead dispatchers

 

CKPT

1.      signalling DBWn at checkpoints

2.      Updating datafile headers and control files with checkpoint information

目录
相关文章
|
28天前
|
Java 应用服务中间件
Process exited with an error: 1 (Exit value: 1) 问题处理
本文介绍了在本地启动项目时遇到“Process exited with an error: 1”错误的解决过程。作者首先排除了配置文件修改的影响,通过分析错误信息,推测为端口占用问题,并使用 `netstat -ano` 命令检查端口占用情况,最终通过终止占用端口的进程解决了问题。
|
6月前
|
机器学习/深度学习 TensorFlow 算法框架/工具
Gaussian Process
【6月更文挑战第14天】
51 4
|
安全 Windows
CRITICAL_PROCESS_DIED
CRITICAL_PROCESS_DIED
4547 2
|
关系型数据库 Java MySQL
|
数据库 网络协议 SQL
|
.NET Windows 开发框架