Oracle 10046
2018-07-12 17:46 WWJD_DBA 阅读(232) 评论(0) 编辑 收藏 举报【10046 SQL】
conn username/password
alter session set tracefile_identifier = 'id_10046';
alter session set timed_statistics = true;
alter session set statistics_level=all;
alter session set max_dump_file_size = unlimited;
alter session set "_rowsource_execution_statistics" = TRUE;
alter session set events '10046 trace name context forever, level 12';
<Run your SQL here;>
rollback;
alter session set events '10046 trace name context off';
【10046 sql_id】
alter session set tracefile_identifier = 'id_10046';
alter session set timed_statistics = true;
alter session set statistics_level=all;
alter session set max_dump_file_size = unlimited;
alter session set "_rowsource_execution_statistics" = TRUE;
alter system set events 'sql_trace [sql:21jthqydpgzy9] level 12';
alter system set events 'sql_trace [sql:21jthqydpgzy9] off';
--查询trc文件路径
select value from v$diag_info where name='Default Trace File';
--格式化trace
$tkprof DB2_ora_45941130_id_10046.trc DB2_ora_45941130_id_10046.log
TKPROF: Release 11.2.0.4.0 - Development on 星期四 7月 12 17:13:36 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
$ls -ltr *log
-rw-r----- 1 oracle oinstall 46076 Jul 12 17:13 DB2_ora_45941130_id_10046.log
作者:wwjd365 WWJD_DBA
出处:http://www.cnblogs.com/wwjd365/
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。