URGENT :- Session 'stuck up' on null event

From: Charu Joshi <joshic_at_mahindrabt.com>
Date: Fri, 3 Sep 2004 13:42:15 +0530
Message-ID: <MHEAIPLKCACENJKNJIALKEAPCGAA.joshic@mahindrabt.com>

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_at_freelists.org&subject=unsubscribe 
To read recent messages - http://freelists.org/archives/oracle-l/09-2004

Received on Fri Sep 03 2004 - 03:07:56 CDT