In TOAD, is there any way to capture the SQL statements of a session, including all values of the bind variables?
There is currently no feature for this.
There is the Current Statement tab in the Session Browser that will track the SQL statements run during a session but this is on the server end and does not include bind variable values.
These is SQL Monitor which will capture SQL to and from the Oracle database and the specific Toad application and session you select. But this is only for Toad and will not trace SQL between the database and other applications. (This may work with some other Quest applications that work with Oracle, like SQL Navigator and Benchmark Factory.)
SOL19313: How to launch SQL Monitor?
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center