gyj@OCM> gyj@OCM> select name from v$event_name where event# in(select to_number('92','xxxxxxxxxxxxxx') from dual);
NAME
----------------------------------------------------------------
db file sequential read
gyj@OCM> select sid from v$mystat where rownum=1;
SID
----------
146
gyj@OCM> select * from gyj_test where id=1;
sys@OCM> select sid ,event from v$session_wait where sid=146 and wait_class<>'Idle';
SID EVENT
---------- ----------------------------------------------------------------
146 read by other session
哈哈。。。终于发现了read by other session等待事件，以后可以用同样的方法去研究其它等待事件！