Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page
Go to next page
View PDF


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.