Temp Usage

We can use view to check temp usage percentage.

RAC / Cloud RDS:

select inst_id, tablespace_name, total_blocks, used_blocks, free_blocks from gv$sort_segment where free_blocks <=0;

NON-RAC / Cloud RDS:

select inst_id, tablespace_name, total_blocks, used_blocks, free_blocks from v$sort_segment where free_blocks <=0;