Monitor the Secure File Migration of CDR_OUTPUT_CLOBS

1. Make sure at least two DBMS SCHEDULER JOBS are scheduled and running. These jobs name starts with MIGRATE_BASICFILE_TO_SECUREFILE_CLOB. Execute the following command to confirm:

   select
   owner,
   job_name,
   JOB_ACTION,
   START_DATE,
   ENABLED,
   STATE
   from dba_SCHEDULER_JOBS
   where job_name like 'MIGRATE_BASICFILE_TO_SECUREFILE_CLOB%';

2. Wait for the BASIC FILE to SECUREFILE migration to complete. You can monitor the migration progress by executing the following command:

   select
           thread_id,
           Number_of_batch_to_processe,
           no_of_processed_batch,
           case when THREAD_ID in (1,2) then 'DBMS JOB SHOULD BE RUNNING'
           when Number_of_batch_to_processe > no_of_processed_batch then 'DBMS        JOB SHOULD BE RUNNING'
           else 'DBMS JOB SHOULD NOT BE RUNNING' end as status
           from
           (
           select thread_id,
           count(distinct batchid) Number_of_batch_to_processe,
           (
           select count(1) 
           from CDR_OUTPUT_CLOBS_SFM_TMP   
           where THREAD_ID=a.THREAD_ID
           and status in ('COMPLETE','FAILED')
           )no_of_processed_batch
           from CDR_OUTPUT_CLOBS_SFM_TMP   a
           group by thread_id
           );