DanBrother的部落格

View

Description

V$ARCHIVE_DEST »

Describes all of the destinations in the Data Guard configuration, including each destination's current value, mode, and status.

Note: The information in this view does not persist across an instance shutdown.

V$ARCHIVE_DEST_STATUS »

Displays runtime and configuration information for the archived redo log destinations.

Note: The information in this view does not persist across an instance shutdown.

V$ARCHIVE_GAP »

Displays information to help you identify a gap in the archived redo log files.

V$ARCHIVED_LOG »

Displays archive redo log information from the control file, including names of the archived redo log files.

V$DATABASE »

Provides database information from the control file. Includes information about fast-start failover (available only with the Data Guard broker).

V$DATABASE_INCARNATION »

Displays information about all database incarnations. Oracle Database creates a new incarnation whenever a database is opened with the RESETLOGS option. Records about the current and the previous incarnation are also contained in the V$DATABASE view.

V$DATAFILE »

Provides datafile information from the control file.

V$DATAGUARD_CONFIG »

Lists the unique database names defined with the DB_UNIQUE_NAME and LOG_ARCHIVE_CONFIG initialization parameters.

V$DATAGUARD_STATS »

Displays how much redo data generated by the primary database is not yet available on the standby database, showing how much redo data could be lost if the primary database were to crash at the time you queried this view. You can query this view on any instance of a standby database in a Data Guard configuration. If you query this view on a primary database, then the column values are cleared.

V$DATAGUARD_STATUS »

Displays and records events that would typically be triggered by any message to the alert log or server process trace files.

V$LOG »

Contains log file information from the online redo log files.

V$LOGFILE »

Contains information about the online redo log files and standby redo log files.

V$LOG_HISTORY »

Contains log history information from the control file.

V$MANAGED_STANDBY »

Displays current status information for Oracle database processes related to physical standby databases.

Note: The information in this view does not persist across an instance shutdown.

V$STANDBY_LOG »

Contains log file information from the standby redo log files.