select
userenv('Instance'), -- INST_ID NUMBER
SID_KRBMROT, -- SID NUMBER
ROWNO_KRBMROT, -- RECID NUMBER
MTS_KRBMROT, -- STAMP NUMBER
L0ID_KRBMROT, -- SESSION_RECID NUMBER
L0TS_KRBMROT, -- SESSION_STAMP NUMBER
TXT_KRBMROT, -- OUTPUT VARCHAR2(130)
ID_KRBMROT, -- RMAN_STATUS_RECID NUMBER
STAMP_KRBMROT, -- RMAN_STATUS_STAMP NUMBER
L0ID_KRBMROT SESSION_KEY -- SESSION_KEY NUMBER
from
x$krbmrot
order by
L0ID_KRBMROT,
L0TS_KRBMROT,
MTS_KRBMROT,
ROWNO_KRBMROT