Connect CDC SQData

The storage agent maintains statistics about the logs that have been mined as well as Storage Pool utilization. These statistics can be very useful to determine if the storage agent is sized correctly. These statistics are also accessed with the display action of SQDCONF and the Capture agent .cab file:

$ sqdconf display /<SQDATA_VAR_DIR>/oracdc1/oracdc1_store.cab

 

SQDC017I sqdconf(pid=0x99) terminated successfully    

SQDF801I Configuration name    : oracdc1              

SQDF802I Configuration key     : cab_964960E67A564AA3

SQDF850I Session Statistics -                        

SQDF851I Txn Max Record        : 44                  

SQDF852I Txn Max Size          : 42386124                    

SQDF853I Txn Max Log Range     : 8207                

SQDF855I Max In-flight Txns    : 0                    

SQDF856I # Txns                : 608                  

SQDF857I # Effective Txns      : 104                  

SQDF861I # Commit Records      : 82                  

SQDF858I # Rollbacked Txns     : 21                  

SQDF859I # Data Records        : 2775                

SQDF860I # Orphan Data Records : 0                    

SQDF862I # Rollbacked Records  : 924                  

SQDF863I # Compensated Records : 0                    

SQDF866I # Orphan Txns         : 0                    

SQDF867I # Mapped Blocks       : 0                    

SQDF868I # Accessed Blocks     : 2                    

SQDF869I # Logical Blocks      : 0                    

SQDF870I Life Statistics -                            

SQDF871I Max Txn Record        : 44                  

SQDF872I Max Txn Size          : 42386124                    

SQDF873I Max Txn Log Range     : 24582                

SQDF875I Max In-flight Txns    : 0                    

SQDF876I # Txns                : 76576            

SQDF877I # Effective Txns      : 27701            

SQDF881I # Commit Records      : 22154            

SQDF878I # Rollbacked Txns     : 5546              

SQDF879I # Data Records        : 752586            

SQDF880I # Orphan Data Records : 0                

SQDF882I # Rollbacked Records  : 243513            

SQDF883I # Compensated Records : 0                

SQDF886I # Orphan Txns         : 0                

SQDF887I # Mapped Blocks       : 48                

SQDF888I # Accessed Blocks     : 2006              

SQDF889I # Logical Blocks      : 48                

SQDC017I sqdconf(pid=0x99) terminated successfully

 

Note:

The following fields give an indication of the storage need for the current workload.

1.Txn Max Record :This indicates the maximum number of records contained in any given transaction. Here the biggest transaction had 44 records.

2.Txn Max Size: This is the maximum size of the payload associated with any given transaction. Here the total amount of data carried by the biggest transaction we’ve seen was a little more than 40MB.

3.Txn Max Log Range: This indicates the largest difference in LSN from start to the end of a transaction.