Temporary tablespace contents can be determined by querying the data dictionary view V$TEMPSEG_USAGE (in Oracle 10g) or V$SORT_USAGE (in Oracle 9i).
Dig Deeper on Oracle database performance problems and tuning
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.