select RECID, -- RECID NUMBER STAMP, -- STAMP NUMBER THREAD#, -- THREAD# NUMBER SEQUENCE#, -- SEQUENCE# NUMBER FIRST_CHANGE#, -- FIRST_CHANGE# NUMBER FIRST_TIME, -- FIRST_TIME DATE NEXT_CHANGE#, -- NEXT_CHANGE# NUMBER RESETLOGS_CHANGE#, -- RESETLOGS_CHANGE# NUMBER RESETLOGS_TIME -- RESETLOGS_TIME DATE from GV$LOG_HISTORY