Pular para o conteúdo

Fóruns Banco de dados Oracle Sistema operacional do servidor Sistema operacional do servidor

#88015
vieri
Participante

    Bem lembrado rodrigo !

    SQL> desc v$database
    Name Null? Type


    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(10)
    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(3)
    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(21)
    FS_FAILOVER_CURRENT_TARGET VARCHAR2(30)
    FS_FAILOVER_THRESHOLD NUMBER
    FS_FAILOVER_OBSERVER_PRESENT VARCHAR2(7)
    FS_FAILOVER_OBSERVER_HOST VARCHAR2(512)