db file parallel write,write complete waits
来源:互联网 发布:人工智能java编程方向 编辑:程序博客网 时间:2024/06/06 18:09
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
SQL> select name,parameter1,parameter2,parameter3,wait_class from v$event_name
2 where name in ('free buffer waits','db file parallel write','write complete waits');
NAME PARAMETER1 PARAMETER2 PARAMETER3 WAIT_CLASS
------------------------- ---------- ---------- ---------- ------------------------------------------------
free buffer waits file# block# set-id# Configuration
write complete waits file# block# Configuration
db file parallel write requests interrupt timeout System I/O
在Oracle 10g中,db file parallel write 被归属为系统I/0等待类,如果你检查到了系统出现了大量的db file parallel write事件,表明你的I/O有问题。这时你可以检查db file parallel write ,write complete waits,free buffer waits的平均等待时间
SQL> select event,time_waited,average_wait from v$system_event where event in
2 ('db file parallel write','write complete waits','free buffer waits');
EVENT TIME_WAITED AVERAGE_WAIT
---------------------------------------------------------------- ----------- ------------
db file parallel write 284 .67
我这里由于是测试机器,没有出现 write complete waits,free buffer waits 等待事件
AVERAGE_WAIT的值应该小于1(百分之一秒),如果AVERAGE_WAIT大于10(十分之一秒),表明非常缓慢的I/O,出现了db file parallel write 时常也会伴随write complete waits等待,如果是非常繁忙的OLTP系统,还可能出现free buffer waits,因为缓慢的I/0势必影响前台进程。db file parallel write只属于DBWR进程独有,不要被名字迷惑了,不要误解为该事件与并行DML有关。
- db file parallel write,write complete waits
- db file parallel write, write complete waits
- db file parallel write,write complete waits
- db file parallel write,write complete waits
- db file parallel write和db file parallel read
- Oracle db file parallel write 和 log file parallel write 等待事件 说明
- Oracle db file parallel write 和 log file parallel write 等待事件 说明
- log file parallel write
- log file parallel write
- 非空闲的等待事件-db file parallel write
- buffer cache —— write complete waits
- I/O上的等待事件 —— db file parallel write
- control file parallel write 等待事件排查
- log file parallel write&&log buffer space
- control file parallel write等待事件
- log file sync和log file parallel write的关系
- log file sync 与 log file parallel write 等待事件
- log file parallel write wait event(摘自sharklove)
- 进程和线程(一)
- cache buffers chains ,buffer busy waits
- 获取HttpServletRequest请求参数的工具类
- 2013年的那点事
- free buffer waits
- db file parallel write,write complete waits
- Linux--poll设备方法
- 第三章 栈和队列
- WEB测试-文本输入框的测试用例
- ASP.NET2.0 文本编辑器FCKeditor (推荐)
- poj 1192 最优连通子集(树形dp)题目好难懂。。。
- VC UI界面库大集合
- 路由器架设虚拟服务器让外网访问到本地网站
- 关于latch