Oracle9i Database Reference Release 2 (9.2) Part Number A96536-01 |
|
Dynamic Performance (V$) Views, 37 of 237
V$DATABASE
contains database information from the control file.
Column | Datatype | Description |
---|---|---|
|
|
Database ID calculated when the database is created and stored in all file headers |
|
|
Name of the database |
|
|
Creation date |
|
|
Change number at open resetlogs |
|
|
Timestamp of open resetlogs |
|
|
Change number at prior resetlogs |
|
|
Timestamp of prior resetlogs |
|
|
Archive log mode ( |
|
|
Last SCN checkpointed |
|
|
Last SCN archived |
|
|
Type of control file:
|
|
|
Control file creation timestamp |
|
|
Control file sequence number incremented by control file transactions |
|
|
Last change number in backup control file (null if the control file is not a backup) |
|
|
Last timestamp in backup control file (null if the control file is not a backup) |
|
|
( |
|
|
Version time |
|
|
Open mode information |
|
|
Protection mode currently in effect for the database:
|
|
|
Aggregated protection mode currently in effect for the database:
Note:This column is an aggregation of the |
|
|
Value of the |
|
|
Number assigned to the database instantiation |
|
|
Current role of the database; either primary or standby |
|
|
Highest |
|
|
Indicates whether switchover is allowed:
|
|
|
Protects data from being changed:
|
|
|
Ensures that LogMiner will have sufficient information to support chained rows and various storage arrangements such as cluster tables. See Oracle9i SQL Reference for additional information about the |
|
|
For all tables with a primary key, ensures that all columns of the primary key are placed into the redo log whenever an update operation is performed. See Oracle9i SQL Reference for additional information about the |
|
|
For all tables with a unique key, ensures that if any unique key columns are modified, all other columns belonging to the unique key are also placed into the redo log. See Oracle9i SQL Reference for additional information about the |
|
|
Indicates whether the database is under force logging mode ( |
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|