Discussion in 'General' started by arunyadav007, Oct 19, 2018.
Quick commands to check Temp space usage
I've posted temporary tablespace information and queries here:
TEMPORARY (Tablespace) Insanity?
Many of the queries in this document are outdated, using sql_address and hash_value rather than sql_id (available since 9i) for queries by a connected user, not using DBA_BLOCKERS to find blocking sessions and completely ignoring important views on TEMP tablespace usage.
If queries are going to be posted it's best to post CURRENT information, not out-dated scripts from the era of Oracle 7.