- 论坛徽章:
- 0
|
本帖最后由 xuhainanjing 于 2013-01-23 15:25 编辑
SYS@single_copy> select view_name,text from dba_views where view_name='V_$DATABASE';
VIEW_NAME TEXT
------------------------------ --------------------------------------------------------------------------------
V_$DATABASE select "DBID","NAME","CREATED","RESETLOGS_CHANGE#","RESETLOGS_TIME","PRIOR_RESET
LOGS_CHANGE#","PRIOR_RESETLOGS_TIME","LOG_MODE","CHECKPOINT_CHANGE#","ARCHIVE_CH
ANGE#","CONTROLFILE_TYPE","CONTROLFILE_CREATED","CONTROLFILE_SEQUENCE#","CONTROL
FILE_CHANGE#","CONTROLFILE_TIME","OPEN_RESETLOGS","VERSION_TIME","OPEN_MODE","PR
OTECTION_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_NAM
E","RECOVERY_TARGET_INCARNATION#","LAST_OPEN_INCARNATION#","CURRENT_SCN","FLASHB
ACK_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
" from v$database
v_$database 到底是table,synonym, 还是view?
|
|