Hi,
Oracle 8.x/9.x
i have a sql to monitor SQL's Temp-Usage, but it's very slow!!
is there a chance to tune it?
Code:
SELECT su.tablespace,
se.sid,
se.user#,
se.serial#,
su.blocks,
su.segtype,
sa.sql_text
FROM v$sort_usage su
,v$sqlarea sa
,v$session se
WHERE su.session_addr = se.saddr
AND se.sql_address = sa.address(+)
The explain-plan :
Code:
SELECT STATEMENT, GOAL = RULE 265 1 734
HASH JOIN OUTER 265 1 734
HASH JOIN 35 1 215
HASH JOIN 23 1 129
FIXED TABLE FULL SYS X$KTSSO 11 20 1460
FIXED TABLE FULL SYS X$KSUSE 11 1 56
FIXED TABLE FULL SYS X$KSUSE 11 1 86
VIEW SYS GV$SQLAREA 229 2000 1038000
FILTER
SORT GROUP BY 229 2000 2128000
FIXED TABLE FULL SYS X$KGLOB 11 2000 2128000
Thanks for help
Orca