select
  s.chain_id,                              -- CHAIN_ID NUMBER
  decode(                                  -- CHAIN_IS_CYCLE VARCHAR2(5)
    s.chain_is_cycle, 0,'FALSE','TRUE'),
  s.chain_signature,                       -- CHAIN_SIGNATURE VARCHAR2(801)
  s.chain_signature_hash,                  -- CHAIN_SIGNATURE_HASH NUMBER
  s.instance,                              -- INSTANCE NUMBER
  s.osid,                                  -- OSID VARCHAR2(25)
  s.pid,                                   -- PID NUMBER
  s.sid,                                   -- SID NUMBER
  s.sess_serial#,                          -- SESS_SERIAL# NUMBER
  decode(                                  -- BLOCKER_IS_VALID VARCHAR2(5)
    s.blocker_is_valid, 0,'FALSE','TRUE'),
  decode(                                  -- BLOCKER_INSTANCE NUMBER
    s.blocker_is_valid, 0, to_number(null), s.blocker_instance),
  s.blocker_osid,                          -- BLOCKER_OSID VARCHAR2(25)
  decode(                                  -- BLOCKER_PID NUMBER
    s.blocker_is_valid, 0, to_number(null), s.blocker_pid),
  decode(                                  -- BLOCKER_SID NUMBER
    s.blocker_is_valid, 0, to_number(null), s.blocker_sid),
  decode(                                  -- BLOCKER_SESS_SERIAL# NUMBER
    s.blocker_is_valid, 0, to_number(null), s.blocker_sess_serial#),
  decode(                                  -- BLOCKER_CHAIN_ID NUMBER
    s.blocker_chain_id, 0, to_number(null), s.blocker_chain_id),
  decode(                                  -- IN_WAIT VARCHAR2(5)
    s.in_wait, 0,'FALSE','TRUE'),
  decode(                                  -- TIME_SINCE_LAST_WAIT_SECS NUMBER
    s.in_wait, 0, s.time_since_last_wait_secs, to_number(null)),
  decode(                                  -- WAIT_ID NUMBER
    s.in_wait, 0, to_number(null), s.wait_id),
  decode(                                  -- WAIT_EVENT NUMBER
    s.in_wait, 0, to_number(null), s.wait_event),
  s.wait_event_text,                       -- WAIT_EVENT_TEXT VARCHAR2(64)
  decode(                                  -- P1 NUMBER
    s.in_wait, 0, to_number(null), s.p1),
  s.p1_text,                               -- P1_TEXT VARCHAR2(64)
  decode(                                  -- P2 NUMBER
    s.in_wait, 0, to_number(null), s.p2),
  s.p2_text,                               -- P2_TEXT VARCHAR2(64)
  decode(                                  -- P3 NUMBER
    s.in_wait, 0, to_number(null), s.p3),
  s.p3_text,                               -- P3_TEXT VARCHAR2(64)
  decode(                                  -- IN_WAIT_SECS NUMBER
    s.in_wait, 0, to_number(null), s.in_wait_secs),
  decode(                                  -- TIME_REMAINING_SECS NUMBER
    s.in_wait, 0, to_number(null), s.time_remaining_secs),
  s.num_waiters,                           -- NUM_WAITERS NUMBER
  decode(                                  -- ROW_WAIT_OBJ# NUMBER
    s.in_wait, 0, to_number(null), s.row_wait_obj#),
  decode(                                  -- ROW_WAIT_FILE# NUMBER
    s.in_wait, 0, to_number(null), s.row_wait_file#),
  decode(                                  -- ROW_WAIT_BLOCK# NUMBER
    s.in_wait, 0, to_number(null), s.row_wait_block#),
  decode(                                  -- ROW_WAIT_ROW# NUMBER
    s.in_wait, 0, to_number(null), s.row_wait_row#) 
from
  X$KSDHNG_CHAINS s