select "USERNAME","USER","SESSION_ADDR","SESSION_NUM","SQLADDR","SQLHASH","SQL_ID","TABLESPACE","CONTENTS","SEGTYPE","SEGFILE#","SEGBLK#","EXTENTS","BLOCKS","SEGRFNO#","TS#","CON_ID","SQL_ID_TEMPSEG" from v$sort_usage
SELECT "USERNAME"
, "USER"
, "SESSION_ADDR"
, "SESSION_NUM"
, "SQLADDR"
, "SQLHASH"
, "SQL_ID"
, "TABLESPACE"
, "CONTENTS"
, "SEGTYPE"
, "SEGFILE#"
, "SEGBLK#"
, "EXTENTS"
, "BLOCKS"
, "SEGRFNO#"
, "TS#"
, "CON_ID"
, "SQL_ID_TEMPSEG"
FROM V$SORT_USAGE
|
|
|