[Oracle工程师手记]如何收集 10046 trace

alter session set tracefile_identifier='10046';

alter session set timed_statistics = true;
alter session set statistics_level=all;
alter session set max_dump_file_size = unlimited;

alter session set events '10046 trace name context forever,level 12';

-- 执行我们想要收集 10046 trace 的 SQL 语句

alter session set events '10046 trace name context off';