Apply Servers:

• IDLE - Performing no work
   

• RECORD LOW-WATERMARK - Performing an administrative action that maintains information about the Apply progress, which is used in the all_apply_progress and dba_apply_progress data dictionary views
   

• ADD PARTITION - Performing an administrative action that adds a partition that is used for recording information about in-progress transactions
   

• DROP PARTITION - Performing an administrative action that drops a partition that was used to record information about in-progress transactions
   

• EXECUTE TRANSACTION - Applying a transaction
   

• WAIT COMMIT - Waiting to commit a transaction until all other transactions with a lower commit SCN are applied. This state is possible only if the commit_serialization Apply process parameter is set to a value other than NONE and the parallelism Apply process parameter is set to a value greater than 1
   

• WAIT DEPENDENCY - Waiting to apply an LCR in a transaction until another transaction, on which it has a dependency, is applied. This state is possible only if the parallelism Apply process parameter is set to a value greater than 1
   

• WAIT FOR NEXT CHUNK - Waiting for the next set of LCRs for a large transaction
   

• TRANSACTION CLEANUP - Cleaning up an applied transaction, which includes removing LCRs from the Apply process queue

The following SQL block shows the details from the apply server.

COL FROM_STREAMS_APPLY_SERVER format a60