Viewing Information About Deferred Transactions for Updatable Materialized Views

At a materialized view site, deferred transactions include changes to updatable materialized views. The deferred transactions are stored at the materialized view site so that they can be sent to the master site and applied to master tables. Deferred transactions for a materialized view are always pushed when a materialized view is refreshed. A scheduled link determines when the deferred transactions are pushed to the master site independent of the refresh process.

To view information about deferred transactions for updatable materialized views: 

1. In Enterprise Manager, log in to the materialized view site as the materialized view administrator. The default user name for the materialized view administrator is mvadmin.

2. Go to the Database Home page.

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

4. Click Manage in the Advanced Replication section.

   The Advanced Replication: Administration page appears, showing the Overview subpage.

5. Click the number associated with Deferred Transactions in the General section to open the Administration: Deferred Transactions page.

   The Administration: Deferred Transactions page contains the transaction ID and the following information for each deferred transaction:

   • The Destination field shows the master site to which the deferred transaction will be pushed.

   • The Start Time field shows when the deferred transaction was placed in the deferred transaction queue at the materialized view site.

   • The Number of Calls field typically shows the number of individual rows changed in the transaction.

6. Click a transaction ID in the Transaction ID column to open the Deferred Transaction page and view more information about the transaction.

   The Deferred Transaction page shows the materialized view and the type of operation that changed it. For example, REP_UPDATE designates an update operation.

7. To view detailed information about a specific change in the deferred transaction, select the change and click Details.

   This page shows each column in the materialized view, along with its original value and, where appropriate, its new value. When there is a new value for a column, then the change modified the column value from the original value to the new value.