Re: URGENT :- Session 'stuck up' on null event

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

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