oracle 如何使用 Toad 跟踪 SQL
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/8831799/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to use Toad to trace SQL
提问by user871695
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?
如何使用 Toad 跟踪我的应用程序正在执行哪些 sql？我想要做的就是跟踪我的应用程序正在执行哪些 SQL/PL/SQL 过程以及正在传递哪些参数？
回答by rkosegi
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?
您不能使用 TOAD 来跟踪由外部应用程序触发的 SQL，但您可以使用会话浏览器来查看基于会话正在执行的查询。还有一个名为 tkprof 的 oracle 实用程序，可用于分析 SQL。另请查看这： Oracle：是否有跟踪查询的工具，例如用于 sql server 的 Profiler？
回答by John Doyle
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.
在 Toad 的商业版本中，您可以使用菜单选项中的 SQL 跟踪器：数据库 > 监控 > SQL 跟踪器。如果您的 Toad 中没有它，那么他们还免费提供 SQL Monitor。关于它的博客在这里。
