1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
|
SELECT username username, SID SID, ktssoses session_addr,
ktssosno session_num, prev_sql_addr sqladdr, prev_hash_value sqlhash,
ktssotsn TABLESPACE,
DECODE (ktssocnt, 0, 'PERMANENT', 1, 'TEMPORARY') CONTENTS,
DECODE (ktssosegt,
1, 'SORT',
2, 'HASH',
3, 'DATA',
4, 'INDEX',
5, 'LOB_DATA',
6, 'LOB_INDEX',
'UNDEFINED'
) segtype,
ktssofno segfile#, ktssobno segblk#, ktssoexts extents,
ktssoblks blocks, ktssorfno segrfno#
FROM x$ktsso, v$session
WHERE ktssoses = v$session.saddr
AND ktssosno = v$session.serial#
AND x$ktsso.inst_id = SYS_CONTEXT ('userenv', 'instance') |
Partager