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.
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屋!