v$database

SQL> select * from v$database;

DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS_TIME PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TIME LOG_MODE CHECKPOINT_CHANGE# ARCHIVE_CHANGE# CONTROLFILE_TYPE CONTROLFILE_CREATED CONTROLFILE_SEQUENCE# CONTROLFILE_CHANGE# CONTROLFILE_TIME OPEN_RESETLOGS VERSION_TIME OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL REMOTE_ARCHIVE ACTIVATION# SWITCHOVER# DATABASE_ROLE ARCHIVELOG_CHANGE# ARCHIVELOG_COMPRESSION SWITCHOVER_STATUS DATAGUARD_BROKER GUARD_STATUS SUPPLEMENTAL_LOG_DATA_MIN SUPPLEMENTAL_LOG_DATA_PK SUPPLEMENTAL_LOG_DATA_UI FORCE_LOGGING PLATFORM_ID PLATFORM_NAME RECOVERY_TARGET_INCARNATION# LAST_OPEN_INCARNATION# CURRENT_SCN FLASHBACK_ON SUPPLEMENTAL_LOG_DATA_FK SUPPLEMENTAL_LOG_DATA_ALL DB_UNIQUE_NAME STANDBY_BECAME_PRIMARY_SCN FS_FAILOVER_STATUS FS_FAILOVER_CURRENT_TARGET FS_FAILOVER_THRESHOLD FS_FAILOVER_OBSERVER_PRESENT FS_FAILOVER_OBSERVER_HOST
---- --------- ----------- ----------------- -------------- ----------------------- -------------------- ------------ ------------------ --------------- ---------------- ------------------- --------------------- ------------------- ---------------- -------------- ------------ ---------- -------------------- -------------------- -------------- ----------- ----------- ---------------- ------------------ ---------------------- -------------------- ---------------- ------------ ------------------------- ------------------------ ------------------------ ------------- ----------- -------------------------------------------------------------------------------- ---------------------------- ---------------------- ----------- ------------------ ------------------------ ------------------------- ------------------------------ -------------------------- --------------------- ------------------------------ --------------------- ---------------------------- --------------------------------------------------------------------------------
1663 TEST 6/29/2009 1 303084659 6/29/2009 10:5 303080709 6/29/2009 10:48:10 A NOARCHIVELOG 324317325 323554083 CURRENT 6/29/2009 10:50:00 109123 324551350 7/24/2009 9:31:4 NOT ALLOWED 6/29/2009 10 READ WRITE MAXIMUM PERFORMANCE UNPROTECTED ENABLED 1663464279 1663464279 PRIMARY 303084659 DISABLED SESSIONS ACTIVE DISABLED NONE NO NO NO NO 4 HP-UX IA (64-bit) 2 2 324582596 NO NO NO TEST 0 DISABLED 0


Describe V$database


SQL> describe v$database
Name Type Nullable Default Comments
---------------------------- ------------- -------- ------- --------
DBID NUMBER Y
NAME VARCHAR2(9) Y
CREATED DATE Y
RESETLOGS_CHANGE# NUMBER Y
RESETLOGS_TIME DATE Y
PRIOR_RESETLOGS_CHANGE# NUMBER Y
PRIOR_RESETLOGS_TIME DATE Y
LOG_MODE VARCHAR2(12) Y
CHECKPOINT_CHANGE# NUMBER Y
ARCHIVE_CHANGE# NUMBER Y
CONTROLFILE_TYPE VARCHAR2(7) Y
CONTROLFILE_CREATED DATE Y
CONTROLFILE_SEQUENCE# NUMBER Y
CONTROLFILE_CHANGE# NUMBER Y
CONTROLFILE_TIME DATE Y
OPEN_RESETLOGS VARCHAR2(11) Y
VERSION_TIME DATE Y
OPEN_MODE VARCHAR2(10) Y
PROTECTION_MODE VARCHAR2(20) Y
PROTECTION_LEVEL VARCHAR2(20) Y
REMOTE_ARCHIVE VARCHAR2(8) Y
ACTIVATION# NUMBER Y
SWITCHOVER# NUMBER Y
DATABASE_ROLE VARCHAR2(16) Y
ARCHIVELOG_CHANGE# NUMBER Y
ARCHIVELOG_COMPRESSION VARCHAR2(8) Y
SWITCHOVER_STATUS VARCHAR2(20) Y
DATAGUARD_BROKER VARCHAR2(8) Y
GUARD_STATUS VARCHAR2(7) Y
SUPPLEMENTAL_LOG_DATA_MIN VARCHAR2(8) Y
SUPPLEMENTAL_LOG_DATA_PK VARCHAR2(3) Y
SUPPLEMENTAL_LOG_DATA_UI VARCHAR2(3) Y
FORCE_LOGGING VARCHAR2(3) Y
PLATFORM_ID NUMBER Y
PLATFORM_NAME VARCHAR2(101) Y
RECOVERY_TARGET_INCARNATION# NUMBER Y
LAST_OPEN_INCARNATION# NUMBER Y
CURRENT_SCN NUMBER Y
FLASHBACK_ON VARCHAR2(18) Y
SUPPLEMENTAL_LOG_DATA_FK VARCHAR2(3) Y
SUPPLEMENTAL_LOG_DATA_ALL VARCHAR2(3) Y
DB_UNIQUE_NAME VARCHAR2(30) Y
STANDBY_BECAME_PRIMARY_SCN NUMBER Y
FS_FAILOVER_STATUS VARCHAR2(21) Y
FS_FAILOVER_CURRENT_TARGET VARCHAR2(30) Y
FS_FAILOVER_THRESHOLD NUMBER Y
FS_FAILOVER_OBSERVER_PRESENT VARCHAR2(7) Y
FS_FAILOVER_OBSERVER_HOST VARCHAR2(512) Y

SQL>