Viewing Information About an Apply Process

You can use Enterprise Manager to view information about an apply process. This information includes the apply process status and state, the rules used by the apply process, and other information about the apply process.

To view information about an apply process in Enterprise Manager: 

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. Select the apply process that you want to monitor in the list of components. If necessary, use the search tool to find the apply process, and then select it.

7. Select View Details in Action.

8. Click Go to open the View Apply Details page.

The View Apply Details page includes detailed information about the apply process. It also enables you to display the database objects for which the apply process applies changes. Rules control which database changes are dequeued and applied by an apply process. Use the search tool in the Objects section to display the apply process rules:

• To display all of the rules in the positive rule set, choose Positive Rule Type and click Go. Positive rules instruct an apply process to dequeue and apply changes to database objects.

• To display all of the rules in the negative rule set, choose Negative Rule Type and click Go. Negative rules instruct an apply process not to dequeue changes to database objects.