V$LOGSTDBY

V$LOGSTDBY displays dynamic information about what is happening to the Data Guard log apply services. This view is very helpful when diagnosing performance problems during the logical application of archived redo logs to the standby database, and it can be helpful for other problems. This view is for logical standby databases only.

Column	Datatype	Description
`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.