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 |