Re: Query hangs suddenly

  • From: "Ram Raman" <veeeraman@xxxxxxxxx>
  • To: "Wolfgang Breitling" <breitliw@xxxxxxxxxxxxx>
  • Date: Wed, 28 Feb 2007 20:57:47 -0600


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@xxxxxxxxxxxxx> 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
>---------- ----------
>--------------- -------------------
>         51 SQL*Net message to client
id                                                        1413697536

>#bytes                                                                    1
>0         -1
>             543 WAITED KNOWN TIME
>I do not understand why it waits for "SQL*Net message to client".

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.



Wolfgang Breitling
Centrex Consulting Corporation

Other related posts: