URGENT :- Session 'stuck up' on null event
- From: "Charu Joshi" <joshic@xxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 3 Sep 2004 13:42:15 +0530
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 - //freelists.org/archives/oracle-l/09-2004
Other related posts:
