Pushing Deferred Transactions

As long as each instance in an Advanced Replication environment has one or more job queue processes (Job Queue Processes) and the necessary scheduled links, each server runs a job at a regular interval to execute deferred transactions automatically at targeted destinations.

If you do not want to wait for Oracle to execute a deferred transaction, then manually push all pending deferred transactions for a particular scheduled link.

However, you can not push an individual deferred transaction for execution. When you push a deferred transaction, all of the deferred transactions that use the same database link are also pushed. Typically, all of the deferred transactions for a certain destination site all use the same database link.

Complete the following steps to execute all pending deferred transactions:

1. In Enterprise Manager, connect to the Database Instance Home page as the replication administrator.

2. Click Data Movement.

3. Under the Advanced Replication section, click Manage.

   The Administration Overview page appears.

4. Under General, click the number link next to Scheduled Links to open the Scheduled Links page.

5. On the Scheduled Links page, select the database link for which you want to push the deferred transactions from the Database Link list.

6. Click Push.