V$tempseg_usage

Lists the Contents of the Temporary Tablespace(s), Including Details About Each Temporary Object and Its Associated Session v$sort_usage is the view to open when TEMP fills up: it holds one row per temporary segment in use, with the user, the session, the tablespace and the blocks allocated. Whether the trigger is an …