select inst_id, -- INST_ID NUMBER kxfqsqn, -- DFO_NUMBER NUMBER kxfqsid, -- TQ_ID NUMBER rpad(kxfqsty,10), -- SERVER_TYPE VARCHAR2(10) kxfqscnt, -- NUM_ROWS NUMBER kxfqslen, -- BYTES NUMBER kxfqset, -- OPEN_TIME NUMBER kxfqsavl, -- AVG_LATENCY NUMBER kxfqsdw, -- WAITS NUMBER kxfqsdt, -- TIMEOUTS NUMBER rpad(kxfqssid,10), -- PROCESS VARCHAR2(10) kxfqsiid -- INSTANCE NUMBER from x$kxfqsrow