Re: Waiting sql
- From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- To: rajugaru.vij@xxxxxxxxx
- Date: Thu, 25 Apr 2013 10:55:08 -0300
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@xxxxxxxxx> 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 BlackBerry® from Vodafone--
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
