Viewing Active Capture Process Transactions

You can use Enterprise Manager to view the transactions that are currently being processed by a capture process. Enterprise Manager displays the following information:

• The transaction ID of each transaction

• The cumulative number of messages in the transaction

  In an Oracle Streams replication environment, each message is a logical change record (LCR). If the Streams process is restarted while the transaction is being processed, then this column shows the number of LCRs processed in the transaction since the Streams process was started.

• The system change number (SCN) for the first message in the transaction

• The time when the first message in the transaction was recorded

  In an Oracle Streams replication environment, changes captured by a capture process are recorded in the database redo log.

• The SCN for the last message in the transaction

• The time when the last message in the transaction was recorded

To view the active capture process transactions: 

1. In Oracle Enterprise Manager, log in to the database as the Oracle Streams administrator.

2. Go to the Database Home page.

3. Click Data Movement to open the Data Movement subpage.

4. Click Manage Replication in the Streams section.

   The Streams page appears, showing the Overview subpage.

5. Click Streams to open the Streams subpage.

   The Capture subpage shows general information about each capture process in the database. This information includes capture process status, state, latency, and throughput.

6. Click the number link in the Current Transactions Active field for the capture process.

   The Active Streams Transactions List section displays the active capture process transactions.

   The Total Messages field is always zero for capture processes because it does not apply to capture processes.

7. To drill-down for more information about a transaction, select the transaction and click View Transaction Details.