Oracle XE查询日志 [英] Oracle XE query log

问题描述

在Postgres中，您可以打开查询日志记录，从而生成一个包含任何客户端发出的所有查询的文件.

In Postgres you can switch on query logging, resulting in a file containing all queries issued by any client.

Oracle XE中是否有类似的可能性?如何打开它以及在哪里找到生成的文件?

Is there a similar possibility in Oracle XE? How do I switch it on and where do I find the resulting file?

推荐答案

您将:

更改会话设置sql_trace = true;

alter session set sql_trace=true;

跟踪文件将位于安装目录下的udump子目录中.

The trace file will be in the udump subdirectory under the installation directory.

实际上文档说10g中已弃用sql_trace:

Actually the docs say that sql_trace is deprecated in 10g: http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams205.htm#REFRN10208

看来DBMS_SESSION是现在要走的路:

例如

EXECUTE DBMS_SESSION.SESSION_TRACE_ENABLE(waits => TRUE, binds => FALSE);

http://download.oracle .com/docs/cd/B19306_01/server.102/b14211/sqltrace.htm#CHDDGCCB

这篇关于Oracle XE查询日志的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！