URGENT :- Session 'stuck up' on null event

Dear all,

OS: Solaris
Version: 9.2.0.3

We have a procedure that usually takes 10-15 minutes to complete. Today it's
been running since 2 hours. The procedure is running an INSERT statement.
The v$session_wait view shows the following entry:

SID     SEQ#    EVENT   P1TEXT  P1      P1RAW   P2TEXT  P2      P2RAW   P3TEXT  
P3      P3RAW   WAIT_TIME
SECONDS_IN_WAIT STATE
99      64211   null event              9       0000000000000009                
2043    00000000000007FB                16
0000000000000010        1       5830    WAITED KNOWN TIME

The session is not doing any IO at all.

I have run the SYS.DBMS_SYSTEM.SET_EV() procedure to set the trace in the
culprit session. We don't have direct access to the UDUMP directory so
haven't been able to check if the trace file got created.

I have one query (don't have time to RTFM) - there is a feature in 9i that
prevents a transaction from failing in case of space shortage. How do I
check if that is causing the wait here (apart from using v$session_wait)?

Any help/suggestions will be greatly appreciated.

Thanks & regards,
Charu.


*********************************************************
Disclaimer:          

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*********************************************************
Visit us at http://www.mahindrabt.com

---
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe 
To read recent messages - http://freelists.org/archives/oracle-l/09-2004

Other related posts: