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... Continue Reading →


Blog at

Up ↑