Dynamic Performance (V$) Views, 107 of 238

V$LOGSTDBY

V$LOGSTDBY displays dynamic information about what is happening to the 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.

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
`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 SCN seen by the process. This column is used to confirm the progress of the individual process.