Oracle9i Data Guard Concepts and Administration Release 1 (9.0.1) Part Number A88808-01 |
|
This chapter describes the fixed views that are used in a Data Guard environment. This is a subset of the views that are available for use in a database. This chapter contains the following sections:
The Oracle database contains a set of underlying views that are maintained by the server and accessible to the database administrator. These fixed views are also called dynamic performance views because they are continuously updated while a database is open and in use, and their contents relate primarily to performance.
Although these views appear to be regular database tables, they are not. These views provide data on internal disk structures and memory structures. You can select from these views, but you can never update or alter them.
These view names are prefixed with either V$ or GV$, for example, V$ARCHIVE_DEST
or GV$ARCHIVE_DEST
.
Standard dynamic performance views (V$ fixed views) store information on the local instance. In contrast, global dynamic performance views (GV$ fixed views) store information on all open instances. Each V$ fixed view has a corresponding GV$ fixed view.
In most cases, the information available in fixed views persists across instance shutdowns. However, certain fixed view information is reset when the instance is shut down; these views are specifically identified in this chapter.
For additional information about views, see the Oracle9i Database Reference.
The V$ARCHIVE_DEST
view describes, for the current instance, all the archived redo log destinations, their current value, mode, and status.
This view contains the following columns:
The V$ARCHIVE_DEST_STATUS
view displays runtime and configuration information for the archived redo log destinations.
The V$ARCHIVE_DEST_STATUS
view contains the following columns:
The V$ARCHIVE_GAP
view contains the following columns:
Column | Description |
---|---|
|
Specifies the thread number |
|
Specifies the low number of the log file |
|
Specifies the high number of the log file |
The V$ARCHIVED_LOG
view displays archived redo log information from the control file, including archived log names. This view contains the following columns:
The V$DATABASE
view provides database information from the control file. This view contains the following columns:
The V$DATAFILE
view provides datafile information from the control file. This view contains the following columns:
The V$LOG
view contains log file information from the online redo logs. This view contains the following columns:
The V$LOGFILE
view contains information about the online redo logs. This view contains the following columns:
The V$LOG_HISTORY
view contains log history information from the control file. This view contains the following columns:
The V$MANAGED_STANDBY
view displays current and status information information for some Oracle database server processes related to Data Guard.
The V$MANAGED_STANDBY
view contains the following columns:
The V$STANDBY_LOG
view contains the following columns:
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|