dba_apply
This view displays information about the
Apply processes. This view shows basic configuration details
including the status, rule set names and the apply handlers.
This view helps the DBA examine and rectify any issues
associated with configuration.
The following SQL statement shows details
about Apply process. It gives a multi-line output for each Apply
process.
select
'Apply Name : ' || APPLY_NAME ||
chr(10) ||
'QUEUE_NAME ; ' || QUEUE_NAME ||
chr(10) ||
'APPLY_CAPTURED : ' || APPLY_CAPTURED
|| chr(10) ||
'RULE_SET_NAME : ' || RULE_SET_NAME
|| chr(10) ||
'APPLY_USER : ' || APPLY_USER
|| chr(10) ||
'APPLY_DATABASE_LINK : ' ||
APPLY_DATABASE_LINK || chr(10) ||
'DDL_HANDLER : ' ||
trim(DDL_HANDLER) || chr(10) ||
'PRECOMMIT_HANDLER : ' ||
PRECOMMIT_HANDLER || chr(10) ||
'MESSAGE_HANDLER : ' ||
MESSAGE_HANDLER || chr(10) ||
'STATUS : ' || STATUS ||
chr(10) ||
'MAX_APPLIED_MSG_NUM : ' ||
MAX_APPLIED_Message_number || chr(10) ||
'ERROR_NUMBER : ' || ERROR_NUMBER ||
chr(10) ||
'ERROR_MESSAGE : ' || ERROR_MESSAGE
|| chr(10) ||
'--------------------------------------------------'
apply_profile
from DBA_APPLY
/
