Oracle:是否有跟踪查询的工具，例如用于SQL Server的Profiler? [英] Oracle: is there a tool to trace queries, like Profiler for sql server?

问题描述

我使用sql server，但是我必须使用Oracle DB迁移到应用程序. 为了跟踪我的应用程序查询，在Sql Server中，我使用了出色的Profiler工具. Oracle有什么等效的东西吗?

i work with sql server, but i must migrate to an application with Oracle DB. for trace my application queries, in Sql Server i use wonderful Profiler tool. is there something of equivalent for Oracle?

推荐答案

您可以使用Oracle Enterprise Manager来监视活动会话，正在执行的查询，其执行计划，锁，一些统计信息甚至进度较长的任务栏.

You can use The Oracle Enterprise Manager to monitor the active sessions, with the query that is being executed, its execution plan, locks, some statistics and even a progress bar for the longer tasks.

请参阅: http://下载.oracle.com/docs/cd/B10501_01/em.920/a96674/db_admin.htm#1013955

转到实例"->会话"，并观看每个会话的"SQL"选项卡.

Go to Instance -> sessions and watch the SQL Tab of each session.

还有其他方法.企业管理器只是用漂亮的颜色放置特殊视图中已经可用的内容，例如此处记录的内容: http://www.oracle.com/pls/db92/db92. catalog_views?remark =主页

There are other ways. Enterprise manager just puts with pretty colors what is already available in specials views like those documented here: http://www.oracle.com/pls/db92/db92.catalog_views?remark=homepage

当然，您还可以使用Explain PLAN FOR，TRACE工具和大量其他工具化方式.在企业管理器中，有一些报告涉及最昂贵的SQL查询.您还可以搜索保存在缓存中的最近查询.

And, of course you can also use Explain PLAN FOR, TRACE tool and tons of other ways of instrumentalization. There are some reports in the enterprise manager for the top most expensive SQL Queries. You can also search recent queries kept on the cache.

这篇关于Oracle:是否有跟踪查询的工具，例如用于SQL Server的Profiler?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！