How to use the SQL Tracker tool? (4296041)

SQL Tracker can be used to troubleshoot issues in Toad by allowing you to capture and view the queries being run in the background of Toad. 

  

For example, if you are working in Toad and get an "ORA-00942: Table or view does not exist" or "ORA-01031: Insufficient privileges" error or if not all tables show up or gets displayed in the Schema Browser, you can capture the background queries to see which objects are being queried by Toad. Once you know the objects that are being queried, you can then determine which of those objects you do not have privileges for and get them granted to your user.  Or for hanging  / slow issues, please send the offending SQL to the DBA of that particular database and ask for further assistance.

  

Steps to use SQL Tracker:

   

1) Open Toad for Oracle and connect to your database.

2) Go to the Database menu | Monitor | SQL Tracker.

3) Highlight the 'toad.exe' line in SQL Tracker, and click the Start Monitoring button (green arrow).

4) Go into Toad for Oracle and perform what you want to be monitored.

5) Go back to SQL Tracker to view the output.

  

Note: It is easier to research if you start the monitoring right before you perform the action you want to monitor. That way it only captures what you want to monitor.

  

480 X 270 player for the Support Link Solution pages