alter session set nls_date_format='Mon dd yyyy hh24:mi:ss';
set pages 9999
set markup html on
spool CONFIG.htm
set echo on

select banner from v$version;
select sysdate from dual;
select * from global_name;
select name, cdb from v$database;
select pdb_id, pdb_name, status from cdb_pdbs;

select * from CDB_CAPTURE;
select * from CDB_CAPTURE_PARAMETERS order by capture_name, parameter;
select * from CDB_APPLY;
select * from CDB_APPLY_PARAMETERS order by apply_name, parameter;
select * from DBA_APPLY_DML_CONF_HANDLERS;
select * from DBA_APPLY_REPERROR_HANDLERS;
select * from CDB_XSTREAM_OUTBOUND;
select * from CDB_XSTREAM_OUTBOUND_PROGRESS;
select * from CDB_XSTREAM_INBOUND;
select * from CDB_XSTREAM_INBOUND_PROGRESS;

select * from V$XSTREAM_CAPTURE;
select * from v$streams_apply_reader;
select * from v$streams_apply_coordinator;
select * from v$streams_apply_server;

select apply_name, count(*) from DBA_APPLY_ERROR group by apply_name;

spool off
set markup html off
set echo off