GG General use query

 Replication is not working for a few tables between TS1CG1 to TS1PDB

select * from GG_TABLE_INFO where DB_NAME='TS1CG1' and dest_db='TS1PDB'and SRC_TABLE IN('XXCPD_FACTOR_MASTER','XXCPD_ITEM_PRICING_ATTRIBUTES','XXCPD_XAAS_LIST_PRICES');

select * from GG_TABLE_INFO where DB_NAME='TS1CG1' and dest_db='TS1DMP' and SRC_TABLE IN('XXITM_EGE_BUNDLE_MAPPINGS','MTL_SYSTEM_ITEMS_B','EGO_MTL_SY_ITEMS_EXT_B','XXITM_EGE_ITEM_REQUEST','XXITM_EGE_RELATION_REQUEST','XXITM_EGE_MULTIROW_ATTRS');

select * from REPL_ALERT where REPLICAT_NAME like 'CG124%' AND DB_NAME='TS1CG1';

select * from REPL_ALERT where REPLICAT_NAME like 'CG1PD040%' AND DB_NAME='TS1CG1';

select * from REPL_ALERT where REPLICAT_NAME like 'CG1PDB01%' AND DB_NAME='TS1CG1';

select * from GG_TABLE_INFO where DB_NAME='TS1CG1' and src_table like '%XXCPD_FACTOR_MASTER%' and PROC_TYPE='REPLICAT';

select DISTINCT(PROC_NAME) from gg_table_info where DB_NAME='TS3DMP'

select DISTINCT(PROC_NAME) from gg_table_info where DB_NAME='TS3CG1' and DEST_DB='TS3DMP';

select DISTINCT(PROC_NAME) from gg_table_info where DB_NAME='TS3CG1' and DEST_DB='TS1PDB';

select * from GG_TABLE_INFO where DEST_TABLE= '%CG153%' and DB_NAME='TS3DMP';

SELECT * FROM gg_table_map where dest_table='%CPD_EGE%' and dest_db='TS3DMP';

select * from REPL_ALERT where REPLICAT_NAME like 'CG124%' AND DB_NAME='TS1CG1';

select * from REPL_ALERT where REPLICAT_NAME like 'CG1DM158%' AND DB_NAME='TS3DMP';

select * from REPL_ALERT where REPLICAT_NAME like 'CG1DM158%' AND DB_NAME='TS3CG1';

select * from REPL_ALERT where DB_NAME='TS3CG1';

select * from MBR_host_info where DB_NAME='TS3CG1';

SELECT * FROM MBR_PROC_DETAILS WHERE DB_NAME='TS3CG1';

select * from gg_table_info where DB_NAME='TS3CG1' and DEST_DB='TS3DMP' and DEST_TABLE like '%CPD_EGE_%';

SELECT * FROM MBR_PROC_DETAILS WHERE DB_NAME='TS3DMP';

  select * from v$archived_log where &scn between FIRST_CHANGE# and NEXT_CHANGE#;