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

home |  up  |  mailbox