SERIAL# | 
NUMBER | 
SQL Session serial number. This data is used when joining this view with the V$SESSION and V$PX_SESSION views. | 
LOGSTDBY_ID | 
NUMBER | 
Parallel query slave ID | 
PID | 
VARCHAR2(12) | 
Process ID of the SQL apply process | 
TYPE | 
VARCHAR2(30) | 
Indicates the task being performed by the process (COORDINATOR, APPLIER, ANALYZER, READER, PREPARER, or BUILDER) | 
STATUS_CODE | 
NUMBER | 
Status number (or Oracle error code) belonging to the STATUS message | 
STATUS | 
VARCHAR2(256) | 
Description of the current activity of the process | 
HIGH_SCN | 
NUMBER | 
Highest system change number (SCN) seen by the process. This column is used to confirm the progress of the individual process. |