有metalink的帮个忙

dingning239

附件

dingning239

附件

dingning239

附件

dingning239

终于发完了，太繁琐了

yanyp

麻烦兄弟了，有空来福州，我请你喝酒

yanyp

还有一个google到了Note:421183.1

How To Enable Capture, Propagation, Apply Tracing:Note:421183.1

A. How to Enable Apply tracing on TARGET site

    1.Stop the applyDBMS_APPLY_AD.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);


B. How to Enable Capture tracing on SOURCE site

     1. Stop the capture(DBMS_CAPTURE_ADM.STOP_CAPTURE)
     2. alter system set events '26700 trace name context forever, level 6';
         exec dbms_capture_adm.set_parameter('yourcapturename','trace_level','127');
         exec dbms_capture_adm.start_capture('yourcapturename');
         --- set trace off after 1/2 hour:
    3. To turn off capture tracing:
         exec dbms_capture_adm.set_parameter('yourcapturename','trace_level',null);
         alter system set events '26700 trace name context off';


C. How to Enable Propagation tracing  on SOURCE site

      1. Disable Propagation (exec dbms_aqadm.disable_propagation_schedule)
      2. alter system set job_queue_processes=0;
          alter system set events ' 24040 trace name context forever,level 10';
          alter system set job_queue_processes=5;
     3.  exec dbms.aqadm.enable_propagation_schedule.
     4.  To disable the Propagation tracing
         alter system set events ' 24040 trace name context off';



    How to Enable and Disable propagation



The typical solution is to disable the propagation and then re-enable it. For example, if the queue name is STREAMS_QUEUE owned by STRMADMIN and the destination database link is ORCL2.WORLD, the commands would be:

exec dbms_aqadm.disable_propagation_schedule('STRMADMIN.STREAMS_QUEUE',
                                                                                                            'ORCL2.WORLD');
exe dbms.aqadm.enable_propagation_schedule('STRMADMIN.STREAMS_QUEUE',
                                                                                                            'ORCL2.WORLD');



D. 10046 Tracing for the Streams Processes
    - Open another sqlplus logged SYS AS SYSDBA:
       conn / as sysdba
       oradebug setospid X
       oradebug unlimit
       oradebug Event 10046 trace name context forever, level 4


PS. (X is the process id of the capture process,apply or propagation)
Note 105395.1 Ext/Pub How to find PID for setospid in oradebug

Wait for a while and then close this sqlplus session

Upload the trace produced in udump and job queue process trace in bdump

dingning239

不用客气，大家分享资料么