How to determine source database for an apply
I am trying to determine a source_database for an existing apply process by querying the relevant database views.
I can't see the source_database being a part of DBA_APPLY view, the queue this apply is attached to doesn't have that information neither in DBA_QUEUES.
I believe this information should be available somewhere in the database dictionary.
Any idea?
Thanks,
-Eugene