Waiting sql

From: <rajugaru.vij_at_gmail.com>
Date: Thu, 25 Apr 2013 13:28:39 +0000
Message-ID: 1908202112-1366896513-cardhu_decombobulator_blackberry.rim.net-989695926-_at_b28.c12.bise7.blackberry>



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 Received on Thu Apr 25 2013 - 15:28:39 CEST

Original text of this message