ITPub博客

首页 > 应用开发 > IT综合 > V$sort_usage, where is the definition?

V$sort_usage, where is the definition?

原创 IT综合 作者:netbanker 时间:2008-01-22 02:20:52 0 删除 编辑

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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/67/viewspace-998092/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-06-12

  • 博文量
    20
  • 访问量
    92106