Is there a way to make Replicate set session variables at the beginning of the session to indicate what task it is connecting with?
Example:
begin
dbms_application_info.set_module(module_name => 'repctl.exe', action_name => '<TASK_NAME>');
end;
/
This would make it much easier to trace problems with specific tasks from the Oracle DBA perspective
From case