查询CDC信息
select apply_name, status from dba_apply;
select capture_name, state, total_messages_captured from v$streams_capture;
select group#, thread#, sequence#, archived, status from v$standby_log;
select app.apply_name, q.name, app.status, qt.queue_table
from dba_apply app, dba_queues q, dba_queue_tables qt
where app.apply_user = 'SYS'
and q.owner = 'SYS'
and qt.owner = 'SYS'
and q.name = app.queue_name
and qt.queue_table = q.queue_table
;
select change_table_name,
change_set_name,
source_schema_name,
source_table_name
from change_tables
where change_table_schema = 'CDCPUB'
order by change_table_name;
select streams_name,
streams_type,
table_owner,
table_name,
rule_type,
source_database
from dba_streams_table_rules
where rule_owner = 'SYS'
order by table_name, rule_type, streams_type;
select apply_name, status from dba_apply where apply_user = 'SYS';