Viewing Active and Spilled Apply Process Transactions

You can use Enterprise Manager to view the transactions that are currently being processed by an apply process. Active transactions are transactions with messages that are currently in the buffered queue for the apply process. Spilled transactions are transactions with messages that have spilled from the buffered queue to the hard disk.

Enterprise Manager displays the following information for active transactions:

• The transaction ID of each transaction

• The total number of messages in the transaction

  In an Oracle Streams replication environment, each message is a logical change record (LCR).

• The cumulative number of messages in the transaction

  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

Enterprise Manager displays the following information for spilled transactions:

• The transaction ID of each transaction

• The number of spilled messages in the transaction

  In an Oracle Streams replication environment, each message is a logical change record (LCR).

• The 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 time when the first message in the transaction spilled from the buffered queue to the hard disk (spill create time)

To view active and spilled apply 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.

6. Perform one of the following actions:

   • To view the active apply process transactions, click the number link in the Current Transactions Active field for the apply process.

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

   • To view the spilled apply process transactions, click the number link in the Current Transactions Spilled field for the apply process.

     The Spilled Streams Transactions List section displays the spilled apply process transactions.

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