We downloaded Toad For Oracle Xpert (trial edition, 30 days) and connected to the DB and done a Browse Session, identified our session based on the IP address and username of the originator, and found out the SQL which was being executed and the Execution Plan (an horrific FULL TABLE SCAN immediately evidenced by Toad).
This tool is simply fantastic. You can't live without.
http://www.quest.com/toad-for-oracle/software-downloads.aspx
No comments:
Post a Comment