Golden Gate – Identifying Current Processing Transactions

This is an informational blog post regarding Golden Gate.

When I started working on GG initially, I used to wonder how to identify the transactions that are currently being processed by the Extract and Replicat Processes. Below are the commands to identify the details of transactions.

Source Extract:

ggsci> send extract capture_1, showtrans

Sending SHOWTRANS request to EXTRACT Capture_1 …

————————————————————

XID:                  45.29.805457

Items:                0

Extract:              Capture_1

Redo Thread:          1

Start Time:           2017-01-30:06:49:52

SCN:                  2449.173700075 (10518548607979)

Redo Seq:             21701

Redo RBA:             617923600

Status:               Running


In the above o/p, we see that SCN (10518548607979) is being processes at this moment. If there are no changes in the tables, you may see the below message,

ggsci> send extract Capture_1, showtrans

 

Sending SHOWTRANS request to EXTRACT Capture_1 …

No transactions found

.

Replicat:

ggsci> send replicat Replicat_1, status

Sending STATUS request to REPLICAT Replicat_1 …

Current status: At EOF

Sequence #: 84

RBA: 33694170

0 records in current transaction

In the above o/p, At EOF means, all the transactions are processed and the replicat has no more records to process. If the Replicat is still processing the data, the o/p would be as below.

ggsci > send replicat Replicat_1,status

Sending STATUS request to REPLICAT Replicat_1 …
Current status: Processing data
Sequence #: 1
RBA: 31681839
877 records in current transaction

Advertisements
This entry was posted in Oracle Golden Gate. Bookmark the permalink.

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