There might be few other ways you can find as I know
below one of the way you can get the source database information. If you set it
up heart beat table in target & Source side. By logging into target database
where replicates are running there is
way too you can find source databases information by querying heart beat table.
select * from gguser.ggs_heartbeat;
select SRC_DB,EXTRACT_NAME from gguser.ggs_heartbeat;
-- To find last Commit information
SELECT
ggs_heartbeat.src_db AS src_db,
ggs_heartbeat.extract_name AS extract_name,
ggs_heartbeat.source_commit AS source_commit,
ggs_heartbeat.target_commit AS target_commit
FROM
gguser.ggs_heartbeat
WHERE
ggs_heartbeat.src_db LIKE 'SUNIL%';
