1.10046事件
SQL> alter system set events '10046 trace name context forever, level 12';
完事后:
SQL> alter system set events '10046 trace name context off';
2.10231事件
(数据库坏块时导出数据)
alter system set events='10231 trace name context forever,level 10';
alter system set events '10231 trace name context off';
3. ora-01555,ora-22924报错
alter system set events '600 trace name errorstack forever';
alter system set events '1555 trace name errorstack forever';
alter system set events '22924 trace name errorstack forever';
alter system set events '600 trace name errorstack off';
alter system set events '1555 trace name errorstack off';
alter system set events '22924 trace name errorstack off';