dba_private_temp_tables
differs from user_private_temp_tables
in that it also has the column inst_id
. select table_name, duration, tablespace_name, -- Likely (always?) the name of a temporary tablespace. num_rows, blocks, avg_row_len, last_analyzed, txn_id save_point_num, sid, serial#, owner from user_private_temp_tables;