Friday, July 19, 2013

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