Oracle 11g: trace apply stream
trace apply stream
1.Stop the apply:(DBMS_APPLY_ADM.STOP_APPLY)
2. alter system set events '1349 trace name context forever , level 1024';
3.exec dbms_apply_adm.set_parameter('APPLY_NAME','trace_level',127);
4.Start the apply
5.alter system set events='1349 trace name context off' ;
6.exec dbms_apply_adm.set_parameter('APPLY_NAME','trace_level',null);
No comments:
Post a Comment