Re: Query hangs suddenly

Thanks.

If it has not waited for anything since then should it not be producing the results. What is it doing then? Sorry I dont get it.

On 2/28/07, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
>
> At 12:13 PM 2/28/2007, Ram Raman wrote:
> >Hi all,
> >
> >We have a query which is run everyday and was running OK till last
> >week. The query starts hanging for the past 2 days when run. Oracle
> >is 9.2. We run this query for today's date ("audit_stamp" - See the
> >comment on the query) or yesterday's date and it returns data
> >quickly. But when the audit_stamp is older than the past 2 days, it
> >hangs. The cost from the plan in all the cases is the almost the
> >same using autotrace traceonly.
> >
> >Here is select from V$session_wait for the session:
> >
> > SID EVENT
> >----------
> ----------------------------------------------------------------
> >P1TEXT
> P1
> >----------------------------------------------------------------
> ----------
> >P2TEXT
> P2
> >----------------------------------------------------------------
> ----------
> >P3TEXT
> >P3 WAIT_TIME
> >----------------------------------------------------------------
> >---------- ----------
> >SECONDS_IN_WAIT STATE
> >--------------- -------------------
> > 51 SQL*Net message to client
> >driver
> id 1413697536
>
> >#bytes 1
> >
> >0 -1
> > 543 WAITED KNOWN TIME
> >
> >I do not understand why it waits for "SQL*Net message to client".
> >Thanks.
>
> It is not waiting. The status is "waited known time". The last known
> wait event was "SQL*Net message to client" and it hasn't waited for
> anything (instrumented) since.
>
> >
>
> Regards
>
> Wolfgang Breitling
> Centrex Consulting Corporation
> www.centrexcc.com
>
>
>

--
http://www.freelists.org/webpage/oracle-l