How about trying v$session_wait and v$session_event? That should tell you
what it is waiting for.
Henry
-Original Message-
Sent: Thursday, August 09, 2001 12:45 PM
To: Multiple recipients of list ORACLE-L
Hi all,
I had a developer come to me yesterday and tell me his session had hung,
did you select * from v$lock...for his sid?
-Original Message-
Sent: Thursday, August 09, 2001 12:45 PM
To: Multiple recipients of list ORACLE-L
Hi all,
I had a developer come to me yesterday and tell me his session had hung,
and sure enough it had, he was executing an INSERT into a ta