GV$LOGHIST
select inst_id, -- INST_ID 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) -- SWITCH_CHANGE# NUMBER from x$kcclh

home |  up  |  mailbox