Capture agents keep track of statistical information for the last session and for the lifetime of the configuration file. These statistics can be accessed with the display action of SQDCONF.
$ sqdconf display /<SQDATA_VAR_DIR>/oracdc/oracdc.cab
SQDF901I Configuration file : /<SQDATA_VAR_DIR>/oracdc1/oracdc1.cab
SQDF902I Status : MOUNTED,STARTED
SQDF903I Configuration key : cab_9A4A9EB10ECCB679
SQDF904I Allocated entries : 31
SQDF905I Used entries : 3
SQDF906I Active Database : ORA19IVP
SQDF907I Start Log Point : 0x0
SQDF908I Last Log Point : 0x1aff2621f
SQDF940I Last Log Timestamp :
SQDF987I Last Commit Time : 2013-01-07 21:03:12.617536 (1eb45bf000000000)
SQDF981I Safe Restart Point : 26667014
SQDF986I Safe Remine Point : 26637169
SQDF910I Active User : sqdata
SQDF913I Fix Flags : RETRY,DICT_FROM_LOG
SQDF914I Retry Interval : 30
SQDF919I Active Flags : CDCSTORE,RAW LOG
SQDF915I Active store name : /<SQDATA_VAR_DIR>/oracdc1/oracdc1.cab
SQDF916I Active store id : cab_964960E67A564AA3
SQDF920I Entry : # 0
SQDF930I Key : SQDATA.DEPT
SQDF923I Active Flags : ACTIVE
SQDF928I Last Log Point : 0x1af474000
SQDF950I session # insert : 0
SQDF951I session # delete : 0
SQDF952I session # update : 0
SQDF960I cumul # of insert : 0
SQDF960I cumul # of insert : 0
SQDF961I cumul # of delete : 0
SQDF962I cumul # of update : 27
SQDF925I Active Datastore : cdc:///oracdc/ORATOORA
SQDF920I Entry : # 1
SQDF930I Key : SQDATA.EMP
SQDF923I Active Flags : ACTIVE
SQDF928I Last Log Point : 0x1aff1f000
SQDF950I session # insert : 544
SQDF951I session # delete : 544
SQDF952I session # update : 35811
SQDF960I cumul # of insert : 544
SQDF961I cumul # of delete : 544
SQDF962I cumul # of update : 35919
SQDF925I Active Datastore : cdc:///oracdc/ORATOORA
SQDF920I Entry : # 2
SQDF930I Key : cdc:///oracdc/ORATOORA
SQDF842I Is connected : Yes
SQDF932I Ack Log Point : 0x1aff2309e
SQDF843I Last Connection : 2013-01-07 21:03:33
SQDF844I Last Disconnection : 2013-01-04 19:34:35
SQDF987I Last Commit Time : 2013-01-07 21:03:12.482800 (cabc970f621f0000)
SQDF953I session # records : 24936
SQDF954I session # txns : 1086
SQDF963I cumul # records : 25026
SQDF964I cumul # txns : 1098
SQDF794I Storage Usage
SQDF795I Used : 5 MB
SQDF796I Free : 59 MB
SQDF797I Unallocated : 0 MB
SQDF798I Memory Cache : 8 MB
SQDC017I sqdconf(pid=0x30) terminated successfullyNote:
- An Entry exists for each source and target specified in the configuration.
- The Last Log Point for each individual entry of the configuration, indicates the LSN of the commit point of the most recent transaction that impacted this table. The rest of the statistics are fairly self-explanatory.
- In Storage Usage section: Used is the amount of the Storage Pool currently in use; Free is the amount of currently unused Storage Pool; Unallocated is the portion of the currently defined Storage Pool that has not yet been allocated; Memory Cache is the amount of allocated MEMORY currently in use.