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$MANAGED_STANDBY

V$MANAGED_STANDBY displays current and status information for some Oracle database server processes related to the Data Guard environment for physical standby database only.

Column Datatype Description

PROCESS

VARCHAR2(7)

Type of process whose information is being reported. Possible values are:

  • RFS - remote file server
  • MRP0 - detached recovery server process
  • MR(fg) - foreground recovery session

PID

NUMBER

Operating system process identifier of process

STATUS

VARCHAR2(12)

Current process status. Possible values are:

  • UNUSED - no active process
  • ALLOCATED - process is active but not currently connected to a primary database client
  • CONNECTED - network connection established to a primary database client
  • ATTACHED - process is actively attached and communicating to a primary database client
  • IDLE - process is not performing any activities
  • ERROR - process has failed
  • OPENING - process is opening the archived redo log
  • CLOSING - process has completed archival and is closing the archived redo log
  • WRITING - process is actively writing archived redo log data
  • RECEIVING - process is receiving network communication
  • ANNOUNCING - process is announcing the existence of a potential dependent archived redo log
  • REGISTERING - process is registering the existence of a completed dependent archived redo log
  • WAIT_FOR_LOG - process is waiting for the archived redo log to be completed
  • WAIT_FOR_GAP - process is waiting for the archive gap to be resolved
  • APPLYING_LOG - process is actively applying the archived redo log to the standby database

CLIENT_PROCESS

VARCHAR2(8)

Identifies the corresponding primary database process. Possible values are:

  • ARCHIVAL - foreground (manual) archival process (SQL)
  • ARCH - background ARCn process
  • LGWR - background LGWR process

CLIENT_PID

VARCHAR2(40)

Operating system process identifier of the client process

CLIENT_DBID

VARCHAR2(40)

Database identifier of the primary database

GROUP#

VARCHAR2(40)

Standby redo log group

THREAD#

NUMBER

Archived redo log thread number

SEQUENCE#

NUMBER

Archived redo log sequence number

BLOCK#

NUMBER

Last processed archived redo log block number

BLOCKS

NUMBER

Size of the archived redo log in 512-byte blocks

DELAY_MINS

NUMBER

Archived redo log delay interval in minutes

KNOWN_AGENTS

NUMBER

Total number of standby database agents processing an archived redo log

ACTIVE_AGENTS

NUMBER

Number of standby database agents actively processing an archived redo log