GV$SORT_USAGE
select x$ktsso.inst_id, -- INST_ID NUMBER username, -- USERNAME VARCHAR2(30) username, -- USER VARCHAR2(30) ktssoses, -- SESSION_ADDR RAW(4) ktssosno, -- SESSION_NUM NUMBER prev_sql_addr, -- SQLADDR RAW(4) prev_hash_value, -- SQLHASH NUMBER prev_sql_id, -- SQL_ID VARCHAR2(13) ktssotsn, -- TABLESPACE VARCHAR2(31) decode -- CONTENTS VARCHAR2(9) (ktssocnt, 0, 'PERMANENT', 1, 'TEMPORARY'), decode -- SEGTYPE VARCHAR2(9) (ktssosegt, 1, 'SORT', 2, 'HASH', 3, 'DATA', 4, 'INDEX', 5, 'LOB_DATA', 6, 'LOB_INDEX', 'UNDEFINED'), ktssofno, -- SEGFILE# NUMBER ktssobno, -- SEGBLK# NUMBER ktssoexts, -- EXTENTS NUMBER ktssoblks, -- BLOCKS NUMBER ktssorfno -- SEGRFNO# NUMBER from x$ktsso, v$session where ktssoses = v$session.saddr and ktssosno = v$session.serial#

home |  up  |  mailbox