Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

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

Go to previous page Go to next page
View PDF

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.