The top of your Temp-Ts allocates Blocks is the High-Water-Mark.
This means that the place could be free for new transaction even it is allocated.
You can monitor which SQL uses the temp-Ts actuall.
Recreating Temp will not help you.
You have to identify and tune the SQL's which fill the Temp-Ts
FROM v$sort_usage su
WHERE su.session_addr = se.saddr
AND se.sql_address = sa.address(+)
Originally posted by Seenivas Thanx for ur info and i would like to know which table occupies more space on the tablespace.
You can't create any permanent segment in TEMP tablespace so there is no question of having tables there. TEMP tablespace have segments used for sorting the data.
If you want to monitor the space usage by table in permanent tablespaces then you can use the query Sridhar has provided.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"