Tracing Database Replay
SQL> alter session set events ‘trace[rat_wcr.*] disk=high’;
Session altered.
SQL> BEGIN dbms_workload_capture.start_capture(UNISTR(‘CAPTURE-demo-20100601134908′),UNISTR(‘DATA_PUMP_DIR’), 60, ‘INCLUDE’, FALSE); END;
/
PL/SQL procedure successfully completed.
SQL> alter session set events ‘trace[rat_wcr.*] off’;
Session altered.
and trace file ( just a snippet ) looks like:
2010-06-01 14:12:13.794034 :kecr.c@5992: kecrRecordUserCallBegin: kecrwksz = 1119
2010-06-01 14:12:13.794047 :kecr.c@2259: kecrRecordCheckPGA: Evaluate dynamic filters.
2010-06-01 14:12:13.794068 :kecr.c@9270: kecrReflectFilter: Enabling capture (from 1 to 1)
2010-06-01 14:12:13.794082 :kecr.c@9270: kecrReflectFilter: Enabling capture (from 1 to 1)
2010-06-01 14:12:13.794095 :kecr.c@9270: kecrReflectFilter: Enabling capture (from 1 to 1)
2010-06-01 14:12:13.794114 :kecr.c@2916: kecrSyncStats: DBTime kews cur = 3339845
kecr last sync = 3339845
kews delta = 0
prev kecrdbtm = 0
new kecrdbtm = 0
2010-06-01 14:12:13.794129 :kecr.c@5992: kecrRecordUserCallBegin: kecrwksz = 1199
2010-06-01 14:12:13.794408 :kecr.c@6116: kecrRecordUserCallEnd: Session 138, Parking 0
2010-06-01 14:12:13.794422 :kecr.c@2916: kecrSyncStats: DBTime kews cur = 3342540
kecr last sync = 3339845
kews delta = 2695
prev kecrdbtm = 0
new kecrdbtm = 2695
For reference , these are the actions related to WCR:
WCR: replay client notify
WCR: replay clock
WCR: replay lock order
WCR: Sync context busy
WCR: Record Action Switcher
WCR: Record State Check
WCR: Record SharedDir Check
WCR: Capture Stats Update
KEC Create directory
WCR: Replay Action Switcher
WCR: Replay State Check
WCR: Replay Deadlock Detection
WCR: Replay Stats Update
WCR: Replay Admin Alive Check
WCR: Replay Send References
WCR: Replay remote commit
WCR: Abort capture on IO error
WCR: Replay remote clock propagation
WCR: RAC message context busy
WCR: capture file IO write
WCR: Sync context busy
