select thread#, status, enabled, groups, instance,

       to_char(open_time,'dd-mon-yy hh24:mi') as OPEN_TIME,

       current_group#, sequence#, 

       checkpoint_change#, to_char(checkpoint_time,'dd-mon-yy hh24:mi') as CHECKPOINT_TIME,

       enable_change#, to_char(enable_time,'dd-mon-yy hh24:mi') as ENABLE_TIME,

       disable_change#, to_char(disable_time,'dd-mon-yy hh24:mi') as DISABLE_TIME,

       last_redo_sequence#, last_redo_block,

       last_redo_change#, to_char(last_redo_time,'dd-mon-yy hh24:mi') as LAST_REDO_TIME

from sys.V_$Thread