SQL> select sql_text from v$sqltext a where a.hash_value =
2 (select sql_hash_value from v$session b where b.sid='&sid')
3 /
Enter value for sid: 113
old 2: (select sql_hash_value from v$session b where b.sid='&sid')
new 2: (select sql_hash_value from v$session b where b.sid='113')
no rows selected
SQL>
SQL> l
1* select sid,event,p1,p1text from v$session
SQL> /
SID EVENT P1 P1TEXT
---------- ---------------------------------------------------------------------- ---------- --------------------
2 pmon timer 300 duration
3 VKTM Logical Idle Wait 0
4 rdbms ipc message 300 timeout
5 DIAG idle wait 5 component
6 rdbms ipc message 300 timeout
7 rdbms ipc message 300 timeout
8 DIAG idle wait 5 component
9 rdbms ipc message 300 timeout
10 rdbms ipc message 300 timeout
11 rdbms ipc message 141 timeout
12 rdbms ipc message 100 timeout
SID EVENT P1 P1TEXT
---------- ---------------------------------------------------------------------- ---------- --------------------
13 smon timer 300 sleep time
14 rdbms ipc message 180000 timeout
15 rdbms ipc message 300 timeout
16 ASM background timer 0
17 rdbms ipc message 300 timeout
18 rdbms ipc message 100 timeout
19 wait for unread message on broadcast channel 1807711440 channel context
21 SQL*Net message from client 1650815232 driver id
22 rdbms ipc message 500 timeout
24 SQL*Net message from client 1413697536 driver id
25 rdbms ipc message 300 timeout
SID EVENT P1 P1TEXT
---------- ---------------------------------------------------------------------- ---------- --------------------
26 rdbms ipc message 16027 timeout
27 rdbms ipc message 16295 timeout
28 rdbms ipc message 6000 timeout
29 rdbms ipc message 14959 timeout
30 rdbms ipc message 14001 timeout
31 rdbms ipc message 12751 timeout
32 rdbms ipc message 10073 timeout
33 rdbms ipc message 14068 timeout
34 rdbms ipc message 30000 timeout
35 rdbms ipc message 30000 timeout
36 rdbms ipc message 30000 timeout
SID EVENT P1 P1TEXT
---------- ---------------------------------------------------------------------- ---------- --------------------
37 rdbms ipc message 28372 timeout
38 rdbms ipc message 28250 timeout
39 rdbms ipc message 26123 timeout
40 rdbms ipc message
11.2以后已经把v$session_wait的内容整合到v$session中,
可以通过v$session /v$session_wait找到等待事件,然后关联v$sqltext 试图 通过v$sqltext.hash_value和v$session.sql_hash_value;