dba_apply_key_columns

This view displays information about substitute key columns for all the tables in the database. Substitute key columns are set using the set_key_columns procedure in the dbms_apply_adm

The following SQL statement shows the key columns:

select OBJECT_OWNER, OBJECT_NAME, COLUMN_NAME
from DBA_APPLY_KEY_COLUMNS
/

dba_apply_parameters

This view displays information about the parameters for the Apply processes in the database. It keeps track of the Apply parameters that have been set. The combination of parameter name and its value can be displayed by the following SQL statement:

COLUMN parameter             FORMAT A20
COLUMN value                FORMAT A20
COLUMN set_by_user             FORMAT A20

SELECT apply_name, parameter, value, set_by_user
FROM DBA_APPLY_PARAMETERS
order by apply_name, parameter
/