Monitor the Secure File Migration of CDR_INSTALLATION_LOG

1. Make sure at least two DBMS SCHEDULER JOBS are scheduled and running. These jobs name starts with MIGRATE_BASICFILE_TO_SECUREFILE. 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%';

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_INSTALLATION_LOG_SFM_TMP  
   	where THREAD_ID=a.THREAD_ID
   	and status in ('COMPLETE','FAILED')
   	)no_of_processed_batch
   	from CDR_INSTALLATION_LOG_SFM_TMP  a
   	group by thread_id
   	);