如何监视Oracle上的SQL活动? [英] How can I monitor SQL activity on Oracle?

问题描述

我想找到一个类似于SQL Server Profiler的Oracle工具，但是粗略的搜索没有产生任何好的结果.我只想实时查看我的应用程序对数据库进行的查询.

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.

有什么建议吗?

推荐答案

Quest软件为Oracle提供了一些非常好的工具.我认为 Oracle的Foglight性能分析和 Spotlight 可以满足您的需求.不过不确定Spotlight.

Quest software has some really good tools for Oracle. I think that both Foglight Performance Analysis for Oracle and Spotlight do what you're looking for. Not sure for Spotlight though.

这篇关于如何监视Oracle上的SQL活动?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！