oracle

SELECT process, status, thread#, sequence#, block#, blocks
FROM v$managed_standby
ORDER BY sequence#;

PROCESS   STATUS       THREAD#	  SEQUENCE#  BLOCK#	BLOCKS       
--------- ------------ ---------- ---------- ---------- ----------
DGRD  	  ALLOCATED	0   	    0      	0 	   0
ARCH  	  CONNECTED	0   	    0      	0 	   0
RFS  	  IDLE		0   	    0      	0 	   0
RFS  	  IDLE		1   	    0      	0 	   0
RFS  	  IDLE		0   	    0      	0 	   0
DGRD  	  ALLOCATED	0   	    0      	0 	   0
ARCH  	  CONNECTED	0   	    0      	0 	   0
ARCH  	  CLOSING	1	    3368   	22528      954
ARCH  	  CLOSING	1	    3369   	1  	   5
MRP0  	  APPLYING_LOG	1	    3370   	28    	   1024000
RFS  	  IDLE		1	    3370   	28  	   1

PROCESS
The Oracle background process (e.g., RFS, MRP0, ARCH, DGRD)

STATUS
The current activity of the process (e.g., waiting, transferring logs, applying logs, etc.)

THREAD#
The redo thread the process is working with (typically different threads in RAC; always 1 in single-instance databases)

SEQUENCE#
The sequence number of the redo log being applied or awaited (sequential redo logs generated by LGWR)

BLOCK#
The current block being processed (a block within the redo log)

BLOCKS
The total number of blocks to be processed or transferred