Oraclue

Oracle internals, debugging and undocumented features

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: