For Oracle sources, the job log includes a real-time status of record deletion. You can use the real-time status to monitor the job progress. For example, to determine the amount of time that the job needs to complete the record deletion.

The real-time status is available when the following conditions are true:

The source is an Oracle database.
The entity tables include primary key constraints.
The source connection uses staging and uses the Oracle row ID for deletion.
The source connection does not use Oracle parallel DML for deletion.

The log includes the number of parallel threads that the job creates and the total number of rows that the job needs to delete for each table. The log includes a real-time status of record deletion for each thread. The job writes a message to the log after each time a thread commits rows to the database. The log displays the thread number that issued the commit and the number of rows the thread deleted in the current commit. The log also displays the total number of rows the thread deleted in all commits and the number of rows that the thread must delete in total. The log shows when each thread starts, pauses, resumes, and completes.