How to use Toad to trace SQL

performance oracle profiling toad
user871695 picture user871695 · Jan 12, 2012 · Viewed 33.4k times · Source

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?

Answer

rkosegi picture rkosegi · Jan 12, 2012

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?

Related questions

Inner join vs Where

Is there a difference in performance (in oracle) between Select * from Table1 T1 Inner Join Table2 T2 On T1.ID = T2.ID And Select * from Table1 T1, Table2 T2 Where T1.ID = T2.ID ?

Read More
Difference between Oracle's plus (+) notation and ansi JOIN notation?

What's the difference between using oracle's plus notation (+) over the ansi standard join notation? Is there a difference in performance? Is the plus notation deprecated?

Read More
BETWEEN clause versus <= AND >=

Is there a performance difference between using a BETWEEN clause or using <= AND >= comparisons? i.e. these two queries: SELECT * FROM table WHERE year BETWEEN '2005' AND '2010'; ...and SELECT * FROM table WHERE year >= '2005…

Read More