GV$LOG_HISTORY definition in Oracle Database 10.2 / www.oracledba.ru
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