![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
WAIT EVENT
文章平均质量分 73
zhaojian1988
这个作者很懒,什么都没留下…
展开
-
free buffer waits
free buffer waits:当一个session试图将一个block读入buffer cache,或者由于读一致需要构造cr的block找不到free buffer而产生的等待。 SQL> select name,parameter1,parameter2,parameter3,wait_class from v$event_name where name ='free buffe原创 2015-01-18 15:21:03 · 383 阅读 · 0 评论 -
direct path read,direct path write
direct path read这个等待事件表示Oracle读取数据块直接进入PGA,而非SGA中的Buffer Cache中。 SQL> select name,parameter1,parameter2,parameter3,wait_class from v$event_name where name='direct path read'; NAME原创 2015-01-18 15:30:23 · 398 阅读 · 0 评论 -
db file parallel write,write complete waits
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原创 2015-01-18 15:00:23 · 408 阅读 · 0 评论 -
log file sync, log file parallell write
SQL> select name,parameter1,parameter2,parameter3,wait_class from v$event_name where name in( 'log file sync','log file parallel write'); NAME PARAMETER1 PA原创 2015-01-18 14:33:58 · 366 阅读 · 0 评论