如何监控 Oracle 上的 SQL 活动？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1555535/
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 can I monitor SQL activity on Oracle?
提问by Kevin Babcock
I'd like to find a tool for Oracle that is similar to the SQL Server Profiler, but a cursory search hasn't yielded any good results. I just want to see, in real time, the queries that my application are making against the database.
我想找到一个类似于 SQL Server Profiler 的 Oracle 工具，但粗略搜索并没有产生任何好的结果。我只想实时查看我的应用程序对数据库进行的查询。
Any suggestions?
有什么建议？
采纳答案by Pascal Thivent
Quest software has some really good tools for Oracle. I think that both Foglight Performance Analysis for Oracleand Spotlightdo what you're looking for. Not sure for Spotlight though.
Quest 软件为 Oracle 提供了一些非常好的工具。我认为Foglight Performance Analysis for Oracle和Spotlight都能满足您的需求。虽然不确定 Spotlight。
回答by SeriousCallersOnly
回答by Pop
AWR (automatic workload repository) is the most obvious answer. There's a description here.
AWR（自动工作负载存储库）是最明显的答案。有一个描述在这里。
But Oracle Enterprise Manager has better interface. Read about it here. You have to pay extra, but it gives you the interactivity you're looking for.
但是 Oracle Enterprise Manager 具有更好的界面。在这里阅读。您必须支付额外费用，但它为您提供了所需的交互性。
回答by DCookie
PL/SQL Developer from Allround Automationsis what we use here. More geared towards developers, it does have a session browser which will show locks, SQL statements, etc. Also a nice graphical explain plan window. It's cheaper than TOAD (at last look).
我们在这里使用的是Allround Automations 的PL/SQL Developer 。更适合开发人员，它确实有一个会话浏览器，可以显示锁、SQL 语句等。还有一个很好的图形解释计划窗口。它比 TOAD 便宜（最后看）。
