Breadcrumb

    History table

    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
    

    History

    Process IdProcess NameProcess TypeProcess StateProcess TextProcess SharedUpdated ByUpdated On StartUpdated On EndUpdated SessionCurr ValueMax ValueError Text
    767PROCESS_01processD-NAPEX_PUBLIC_USER24-MAR-202624-MAR-202678591140885441000010000-
    766PROCESS_01processDcompletedNAPEX_PUBLIC_USER24-MAR-202624-MAR-20267859114088544100100-
    765PROCESS_01processDcompletedNAPEX_PUBLIC_USER24-MAR-202624-MAR-20267859114088544100100-
    761J_UC_PROGRESSBAR_SAMPLEJOB_01jobDcompletedYPIP24-MAR-202624-MAR-2026-100100-
    • 1 - 4