在一个session中:
SQL> select sid from v$mystat where rownum show user
USER 为 "SYSTEM"
SQL> select * from
2(select * from dba_tab_columns where rownumselect sid, eventfrom v$session_wait where sid=128;
SID EVENT
---------- ----------------------------------------------------------------
128 control file sequential read