TEMP tablespace - URGENT...

[Orca777]

Hi,
there is no need to coalesce the Temp-Ts.
What you see is the 'Highwatermark' of the Temp-Segment.
The segment can be allocated for a transaction in the past
and now be empty.

Try to identify the SQL's which needs teh temp-Ts,
and tune them or replace the logic of expensive code.

Orca


--
-- KRE CSC SQL's die TEMP belegen
--
SELECT su.tablespace,
se.sid,
se.serial#,
su.blocks,
sa.sql_text
FROM v$sort_usage su
,v$session se
,v$sqlarea sa
WHERE su.session_addr = se.saddr
AND se.sql_address = sa.address
ORDER
BY su.tablespace,
se.sid,
se.serial#,
sa.address