最初由 ZALBB 发布
[B]SQL> select terminal,username,sid,last_call_et,taddr,machine
2 from v$session where status = 'ACTIVE' and username is not null order by last_call_et;
TERMINAL USERNAME SID LAST_CALL_ET TADDR MACHINE
-------------------- -------------------- ---------- ------------ ---------------- --------------
unknown NCTELLING 343 0 s30
ZHANG-HF NCTELLING 516 0 DOMAIN\ZHANG-H
unknown NCTELLING 233 60835 NC-NODE-4
unknown NCTELLING 33 174120 s30
unknown NCTELLING 265 175330 s30
unknown NCTELLING 37 175800 NC-NODE-3
unknown NCTELLING 15 239536 s30
unknown NCTELLING 145 239965 s29
unknown NCTELLING 113 242467 NC-NODE-3
unknown NCTELLING 255 243814 NC-NODE-4
SQL> select * from v$session_wait where sid=255;
SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIME SECONDS_IN_WAIT STATE
----- ------ ----------------------------- ---------- ---------- ---------------- ------- --- ---------------- ------- --- ------ ---------- --------------- -------------------
255 48399 SQL*Net message from client driver id 1952673792 0000000074637000 #bytes 1 0000000000000001 0 00 -1 243853 WAITED KNOWN TIME
从第1句SQL,看出,会话255还在忙(status=ACTIVE),但
第2句,会话的等待事件确实SQL*Net message from client,
而类型wait_time= -1,这意味着什么?若说它在等待资源,
那如何跟踪? [/B]