How can i know, what are the SQL_Texts of the statements that are using the Temporary TS ? We are using this one:
SELECT s.username, u."USER", u.tablespace, u.contents,
u.extents, u.blocks, a.sql_text, u.sqladdr, u.sqlhash
FROM v$session s, v$sort_usage u, v$sql a
WHERE s.SADDR = u.SESSION_ADDR
and a.hash_value = u.sqlhash and u.contents = 'TEMPORARY'
Is this one right or not ?
Do you have another one ?
(Related to the thread i posted earlier: When the Temporary Tablespace is used ? )
