oracle通过select * from v$database;查询库信息
2016-01-13 10:09:20 访问(1939) 赞(0) 踩(0)
select * from v$database;
SQL> desc 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(20) 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(22) 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
CONTROLFILE_CONVERTED VARCHAR2(3) Y
PRIMARY_DB_UNIQUE_NAME VARCHAR2(30) Y
SUPPLEMENTAL_LOG_DATA_PL VARCHAR2(3) Y
MIN_REQUIRED_CAPTURE_CHANGE# NUMBER Y
标签：
oracle通过select * from v$database;查询库信息 
上一条：
下一条：
相关评论
发表评论