告警日志位置:
show parameter background_dump_dest
log_checkpoints_to_alter
SQL跟踪:
show parameter user_dump_dest
alter session set sql_trace=true;
select * from emp;
alter session set sql_trace=false;
cd user_dump_dest/sid/udump
tkprof .......(时间最新的文件)
10046事件:
alter session set events '10046 trace name context forever, level 1';
alter session set events '10046 trace name context off';
转载于:https://blog.51cto.com/feirr/1383689