Friday, August 27, 2010

Toad For Oracle Xpert is your friend

Tonight we were facing a Tx timeout while persisting data to a Oracle DB using EclipseLink JPA.
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.

No comments: