3

How to use Toad to trace what sql are being executed by my application? All I want to do is trace what SQL / PL/SQL procedures are being executed by my application and what parameters are being passed?

Sathyajith Bhat
  • 21,321
  • 22
  • 95
  • 134
user871695
  • 431
  • 4
  • 7
  • 14
  • 2
    You have a bunch of questions that have been answered and has obviously helped you, but you have not [accepted them](http://u.sbhat.me/t6SXUH). Please do else people may be not be inclined to help you. – Sathyajith Bhat Jan 12 '12 at 09:54

2 Answers2

3

You can not use TOAD to trace SQL fired by external application, but you can utilize session browser to see what queries are being executed on session basis.There is also oracle utility called tkprof which can be used to profile SQL.Also take a look at this : Oracle: is there a tool to trace queries, like Profiler for sql server?

Community
  • 1
  • 1
rkosegi
  • 14,165
  • 5
  • 50
  • 83
3

In the commercial version of Toad you can use the SQL Tracker which is found in the menu option: Database > Monitor > SQL Tracker. If you don't have that as part of your Toad then they also offer SQL Monitor for free. A blog about it is here.

John Doyle
  • 7,475
  • 5
  • 33
  • 40