GV$LOG_HISTORY
select x$kcclh.inst_id, -- INST_ID NUMBER lhrid, -- RECID NUMBER lhstm, -- STAMP NUMBER lhthp, -- THREAD# NUMBER lhseq, -- SEQUENCE# NUMBER to_number (lhlos), -- FIRST_CHANGE# NUMBER to_date -- FIRST_TIME DATE (lhlot, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'), to_number (lhnxs), -- NEXT_CHANGE# NUMBER to_number (lhrls), -- RESETLOGS_CHANGE# NUMBER to_date -- RESETLOGS_TIME DATE (lhrlc, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian') from x$kcclh

home |  up  |  mailbox