Re: Waiting sql
From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Thu, 25 Apr 2013 10:55:08 -0300
Message-ID: <CAJ2dSGSUHvoPVGV_2SYozxQzVtRnV4ZQXwe5OyvZzRUeQK_0hA_at_mail.gmail.com>
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.
Date: Thu, 25 Apr 2013 10:55:08 -0300
Message-ID: <CAJ2dSGSUHvoPVGV_2SYozxQzVtRnV4ZQXwe5OyvZzRUeQK_0hA_at_mail.gmail.com>
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 BlackBerry® from Vodafone--
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 25 2013 - 15:55:08 CEST