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