GV$DATABASE definition in Oracle 8i / www.oracledba.ru
GV$DATABASE
select
inst_id, -- INST_ID NUMBER
didbi, -- DBID NUMBER
didbn, -- NAME VARCHAR2(9)
to_date -- CREATED DATE
(dicts, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (dirls), -- RESETLOGS_CHANGE# NUMBER
to_date -- RESETLOGS_TIME DATE
(dirlc, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (diprs), -- PRIOR_RESETLOGS_CHANGE# NUMBER
to_date -- PRIOR_RESETLOGS_TIME DATE
(diprc, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
decode -- LOG_MODE VARCHAR2(12)
(bitand (diflg, 1), 0, 'NOARCHIVELOG', 'ARCHIVELOG'),
to_number (discn), -- CHECKPOINT_CHANGE# NUMBER
to_number (difas), -- ARCHIVE_CHANGE# NUMBER
decode -- CONTROLFILE_TYPE VARCHAR2(7)
(bitand (diflg, 256), 256, 'CREATED', decode (bitand (diflg, 1024), 1024, 'STANDBY', decode (bitand (diflg, 32768), 32768, 'CLONE', decode (bitand (diflg, 4096), 4096, 'BACKUP', 'CURRENT')))),
to_date -- CONTROLFILE_CREATED DATE
(dicct, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
dicsq, -- CONTROLFILE_SEQUENCE# NUMBER
to_number (dickp_scn), -- CONTROLFILE_CHANGE# NUMBER
to_date -- CONTROLFILE_TIME DATE
(dickp_tim, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
decode -- OPEN_RESETLOGS VARCHAR2(11)
(bitand (diflg, 4), 4, 'REQUIRED', decode (diirs, 0, 'NOT ALLOWED', 'ALLOWED')),
to_date -- VERSION_TIME DATE
(divts, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
decode -- OPEN_MODE VARCHAR2(10)
(didor, 0, 'MOUNTED', decode (didor, 1, 'READ WRITE', 'READ ONLY'))
from
x$kccdi