VIEW: SYS.V_$DATABASE

Source

View Text - Preformatted

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 v$database

View Text - HTML Formatted

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 V$DATABASE