Select /*+ ORDERED */ substr(s.ksusemnm, 1, 10) || '-' || substr(s.ksusepid, 1, 10) "ORIGIN", substr(g.K2GTITID_ORA, 1, 35) "GTXID", substr(s.indx, 1, 4) || '.' || substr(s.ksuseser, 1, 5) "LSESSION", substr(decode(bitand(ksuseidl, 11), 1, 'ACTIVE', 0, decode(bitand(ksuseflg, 4096), 0, 'INACTIVE', 'CACHED'), 2, 'SNIPED', 3, 'SNIPED', 'KILLED'), 1, 1) "S", substr(event, 1, 10) "WAITING" from x$k2gte g, x$ktcxb t, x$ksuse s, v$session_wait w where g.K2GTDXCB = t.ktcxbxba and g.K2GTDSES = t.ktcxbses and s.addr = g.K2GTDSES and w.sid = s.indx;