如何监视所有执行的sql语句作为单个事务的结果 [英] How to monitor all the executed sql statements as a result of single transaction

问题描述

我正在将我们的服务器从一个版本升级到其他版本。为此，我需要在单个事务中执行的所有查询的详细信息。
我启用跟踪日志，但这是一个冗长的过程，因为它包含系统相关的查询也.AWR报告似乎不工作。
我使用oracle 10/11 g.Is开发人员有任何其他方法来实现这个目标。

I am in the process of upgrading our server from one version to other.So for this purpose i need the detail of all the queries executing in single transaction. I am enabling trace logs for that but that is a tedious process as it contains system related queries also.AWR reports seems to be not working. I am using oracle 10/11 g.Is there any other way in sql developer to achieve this goal.

推荐答案

跟踪是查看所有语句执行的唯一方法。 AWR通过对活动会话进行采样来工作;这显着减少了开销和数据，但提供了大量的性能调整信息。

Tracing is the only way to see all statements executed. AWR works by sampling active sessions; this significantly cuts down on the overhead and data yet provides plenty of information for performance tuning. But this means that AWR will miss many queries that run very quickly.

要移除递归查询，您可以通过 tkprof 使用选项 sys = no 。

To remove recursive queries you can run the trace file through tkprof with the option sys=no.

这篇关于如何监视所有执行的sql语句作为单个事务的结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！