eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.V_$DATABASE

Object Details

Object Name:	V_$DATABASE
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
DBID	NUMBER
NAME	VARCHAR2	(9)
CREATED	DATE
RESETLOGS_CHANGE#	NUMBER
RESETLOGS_TIME	DATE
PRIOR_RESETLOGS_CHANGE#	NUMBER
PRIOR_RESETLOGS_TIME	DATE
LOG_MODE	VARCHAR2	(12)
CHECKPOINT_CHANGE#	NUMBER
ARCHIVE_CHANGE#	NUMBER
CONTROLFILE_TYPE	VARCHAR2	(7)
CONTROLFILE_CREATED	DATE
CONTROLFILE_SEQUENCE#	NUMBER
CONTROLFILE_CHANGE#	NUMBER
CONTROLFILE_TIME	DATE
OPEN_RESETLOGS	VARCHAR2	(11)
VERSION_TIME	DATE
OPEN_MODE	VARCHAR2	(20)
PROTECTION_MODE	VARCHAR2	(20)
PROTECTION_LEVEL	VARCHAR2	(20)
REMOTE_ARCHIVE	VARCHAR2	(8)
ACTIVATION#	NUMBER
SWITCHOVER#	NUMBER
DATABASE_ROLE	VARCHAR2	(16)
ARCHIVELOG_CHANGE#	NUMBER
ARCHIVELOG_COMPRESSION	VARCHAR2	(8)
SWITCHOVER_STATUS	VARCHAR2	(20)
DATAGUARD_BROKER	VARCHAR2	(8)
GUARD_STATUS	VARCHAR2	(7)
SUPPLEMENTAL_LOG_DATA_MIN	VARCHAR2	(8)
SUPPLEMENTAL_LOG_DATA_PK	VARCHAR2	(3)
SUPPLEMENTAL_LOG_DATA_UI	VARCHAR2	(3)
FORCE_LOGGING	VARCHAR2	(39)
PLATFORM_ID	NUMBER
PLATFORM_NAME	VARCHAR2	(101)
RECOVERY_TARGET_INCARNATION#	NUMBER
LAST_OPEN_INCARNATION#	NUMBER
CURRENT_SCN	NUMBER
FLASHBACK_ON	VARCHAR2	(18)
SUPPLEMENTAL_LOG_DATA_FK	VARCHAR2	(3)
SUPPLEMENTAL_LOG_DATA_ALL	VARCHAR2	(3)
DB_UNIQUE_NAME	VARCHAR2	(30)
STANDBY_BECAME_PRIMARY_SCN	NUMBER
FS_FAILOVER_STATUS	VARCHAR2	(22)
FS_FAILOVER_CURRENT_TARGET	VARCHAR2	(30)
FS_FAILOVER_THRESHOLD	NUMBER
FS_FAILOVER_OBSERVER_PRESENT	VARCHAR2	(7)
FS_FAILOVER_OBSERVER_HOST	VARCHAR2	(512)
CONTROLFILE_CONVERTED	VARCHAR2	(3)
PRIMARY_DB_UNIQUE_NAME	VARCHAR2	(30)
SUPPLEMENTAL_LOG_DATA_PL	VARCHAR2	(3)
MIN_REQUIRED_CAPTURE_CHANGE#	NUMBER
CDB	VARCHAR2	(3)
CON_ID	NUMBER
PENDING_ROLE_CHANGE_TASKS	VARCHAR2	(512)
CON_DBID	NUMBER
FORCE_FULL_DB_CACHING	VARCHAR2	(3)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
,      CONTROLFILE_CONVERTED
,      PRIMARY_DB_UNIQUE_NAME
,      SUPPLEMENTAL_LOG_DATA_PL
,      MIN_REQUIRED_CAPTURE_CHANGE#
,      CDB
,      CON_ID
,      PENDING_ROLE_CHANGE_TASKS
,      CON_DBID
,      FORCE_FULL_DB_CACHING
FROM SYS.V_$DATABASE;

Dependencies

[top of page]

SYS.V_$DATABASE references the following:

SYS.V_$DATABASE is referenced by following:

DBSNMP: BSLN_INTERNAL - show dependent code; BSLN_INTERNAL - show dependent code
DVSYS: DBMS_MACADM - show dependent code
PUBLIC: V$DATABASE