V$DATABASE

Data Dictionary View

Columns
   ___________________________
 
   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#
   DATABASE_ROLE
   ARCHIVELOG_CHANGE#
   SWITCHOVER_STATUS
   DATAGUARD_BROKER
   GUARD_STATUS
   SUPPLEMENTAL_LOG_DATA_MIN
   SUPPLEMENTAL_LOG_DATA_PK
   SUPPLEMENTAL_LOG_DATA_UI
   FORCE_LOGGING

Examples

select NAME, LOG_MODE, CREATED from v$database;

Related:

V$ACTIVE_INSTANCES 
V$BGPROCESS 
V$BH 
V$COMPATIBILITY 
V$COMPATSEG 
V$COPY_CORRUPTION 
V$DATAFILE 
V$DBFILE 
V$DBLINK 
V$DB_PIPES 
V$INSTANCE 
V$LICENSE 
V$OFFLINE_RANGE 
V$OPTION 
V$SGA 
V$SGASTAT 
V$TABLESPACE 
V$VERSION


© Copyright SS64.com 1999-2013
Some rights reserved