GV$FAST_START_TRANSACTIONS
SELECT inst_id, -- INST_ID NUMBER usn, -- USN NUMBER slt, -- SLT NUMBER seq, -- SEQ NUMBER state, -- STATE VARCHAR2(16) wkd, -- UNDOBLOCKSDONE NUMBER twk, -- UNDOBLOCKSTOTAL NUMBER pid, -- PID NUMBER etime, -- CPUTIME NUMBER parentusn, -- PARENTUSN NUMBER parentslt, -- PARENTSLT NUMBER parentseq, -- PARENTSEQ NUMBER xid, -- XID RAW(8) pxid, -- PXID RAW(8) svrs -- RCVSERVERS NUMBER from x$ktprxrt UNION ALL SELECT inst_id, -- INST_ID NUMBER usn, -- USN NUMBER slt, -- SLT NUMBER seq, -- SEQ NUMBER state, -- STATE VARCHAR2(16) twk-wkl, -- UNDOBLOCKSDONE NUMBER twk, -- UNDOBLOCKSTOTAL NUMBER NULL, -- PID NUMBER etime, -- CPUTIME NUMBER NULL, -- PARENTUSN NUMBER NULL, -- PARENTSLT NUMBER NULL, -- PARENTSEQ NUMBER xid, -- XID RAW(8) NULL, -- PXID RAW(8) svrs -- RCVSERVERS NUMBER from x$kturhist

home |  up  |  mailbox