Re: URGENT :- Session 'stuck up' on null event
- From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 3 Sep 2004 10:22:31 +0100
<QUOTE>
Views Containing Information About Resumable Statements
The following views can be queried to obtain information about the
status of resumable statements:
View Description
DBA_RESUMABLE
USER_RESUMABLE
These views contain rows for all currently executing or suspended
resumable statements. They can be used by a DBA, AFTER SUSPEND
trigger, or another session to monitor the progress of, or obtain
specific information about, resumable statements.
V$SESSION_WAIT
When a statement is suspended the session invoking the statement is
put into a wait state. A row is inserted into this view for the
session with the EVENT column containing "statement suspended, wait
error to be cleared".
</QUOTE>
HTH
-Ganesh
On Fri, 3 Sep 2004 13:42:15 +0530, Charu Joshi <joshic@xxxxxxxxxxxxxx> wrote:
>
> 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
>
---
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
To read recent messages - //freelists.org/archives/oracle-l/09-2004
Other related posts:
