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