V$sort_usage, where is the definition?-CSDN博客

GV$SORT_USAGE

you may need it sometimes when your temp gets blew without any reason during the nite :-)

[@more@]

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
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# NUMBERfrom
x$ktsso,
v$session
where
ktssoses = v$session.saddr and ktssosno = v$session.serial#