The plugin works on the UC_PROGRESSBAR table (collection) this way we can also hold history if needed.
Setting how long our history will be saved can be set inside the package "UC_PROGRESSBAR_PKG" with the parameter
g_history_days constant number := 30;
In case we are using "Job" type processes as a long-running job, here is also an option to use "dbms_application_info". The option is enabled by default with the following line:
g_use_dbms_application_info constant boolean := true;
You can check execution as DBA with :
select sid, sql_id, opname, target_desc, sofar, totalwork, start_time, elapsed_seconds, time_remaining, message
from v$session_longops
where where time_remaining > 0