Oracle Technology‎ > ‎Database‎ > ‎database notes‎ > ‎

RAC threads

posted 20 May 2014, 07:46 by Alan Nolan-Davies
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
Comments