RE: Waiting sql

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Thu, 25 Apr 2013 10:33:40 -0400
Message-ID: <00e601ce41c1$e217fec0$a647fc40$_at_rsiz.com>



Mr. Bort is correct if you're waiting for some resource incrementally supplying your query's needs.

First I'd probably determine your sid and then

select * from dba_waiters where waiting_session = <session of interest's sid>;

from another session to see if there is a logical wait (aka a blocker) in your way.

If that returns anything, then you can investigate the sessions listed in the column holding_session.
If that returns nothing, then you're waiting for something to grind out incrementally.

mwf

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Guillermo Alan Bort
Sent: Thursday, April 25, 2013 9:55 AM
To: rajugaru.vij_at_gmail.com
Cc: oracle-l-freelists
Subject: Re: Waiting sql

You can look at the waits for the session issuing the query: v$sesstat, v$waitstat, v$statname Alternatively you can use toad's session browser.

or you can run a trace and tkprof the output to get a report on what the session is waiting for.

cheers

Alan.-

On Thu, Apr 25, 2013 at 10:28 AM, <rajugaru.vij_at_gmail.com> wrote:

> Hi,
> Iam trying to run a query, which is taking 13 to 14 minutes. Its cost
> is 70. Its waiting for something. How to know for what my query is
> waiting and taking so long.
>
> Thanks
> Sent on my BlackBerryR from Vodafone--
> http://www.freelists.org/webpage/oracle-l
>
>
>

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


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 25 2013 - 16:33:40 CEST

Original text of this message