How to monitor temp tablespace usage?

At times you may have a scenario where you may want to monitor temp space usage in a running session. So using the following PL/SQL code loops which inserts every interval on temp usage for a specific sid (session id). create table monitor_usage ( RUN_DATE DATE, BLOCKS NUMBER(38), BYTES NUMBER(38), APP VARCHAR2(10) ); declare cursor l_cur IS SELECT sysdate, b.blocks, b.blocks*d.value bytes FROM v$session a, … Continue reading How to monitor temp tablespace usage?