蔡骏天机 全本下载:read by other session
来源:百度文库 编辑:九乡新闻网 时间:2024/05/03 05:59:00
read by other session是在Oracle Database 10g中,引入的一个新事件,此前版本,这个事件在Buffer Busy Wait中记录。
根据文档,这个事件的解释如下:
这个等待也就是说明数据库存在读的竞争,所以该等待事件通常和db file sequential read或db file scattered read 同时出现。
以下是一个客户生产数据库中的Top 5 Timed Events:
根据文档,这个事件的解释如下:
This event occurs when a session requests a buffer that is currently being read into the buffer cache
by another session. Prior to release 10.1, waits for this event were grouped with the other reasons for
waiting for buffers under the 'buffer busy wait' event
这个等待也就是说明数据库存在读的竞争,所以该等待事件通常和db file sequential read或db file scattered read 同时出现。
以下是一个客户生产数据库中的Top 5 Timed Events:
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
CPU time 4,897 52.9
db file sequential read 1,557,308 1,887 1 20.4 User I/O
read by other session 3,818,768 1,769 0 19.1 User I/O
db file scattered read 973,678 807 1 8.7 User I/O
log file sync
可通过如下SQL语句查看竞争的数据块:SELECT p1 “file#”,p2 “block#”,p3 “class#” FROM v$session_wait WHERE event = 'read by other session';
read by other session
有关read by other session 的等待事件
read
read
"How to Read a Book" by Mortimer J. Adler & C...
other,the other, others,
Session 详解
other,the other, others, the others,another
other,the other, others, the others
other,the other, others, the others,another
other,the other, others, the others,
read it
Fourth Plenary Session
ASH(Active Session History)
Oracle V$SESSION
Cookie和Session专题
other,the other, others, the others,another的用法
There's No Other Way
[other,others,another的用法]
this shore,the other shore
other,others,another的用法!
other,others,another的用法
java http session状态保持
read修复工具下载