Oracle TEMP Tablespace

TEMPORARY_TABLESPACE TEMP_MAX_SIZE_MB DAY MAX_TEMP_PER_DAY_MB-------------------- ---------------- -------------------- -------------------TEMP 32,767 10-JUN-2022 00:00:00 1,665TEMP 32,767 11-JUN-2022 00:00:00 1,059TEMP 32,767 12-JUN-2022 00:00:00 1,141TEMP 32,767 13-JUN-2022 00:00:00 949TEMP 32,767 14-JUN-2022 00:00:00 3,091TEMP 32,767 15-JUN-2022 00:00:00 1,131TEMP 32,767 16-JUN-2022 00:00:00 32,702TEMP 32,767 17-JUN-2022 00:00:00 902

Historical TEMP Tablespace Usage Per Minute

AWR/ASH

TEMPORARY_TABLESPACE SAMPLE_TIME SUM_MAX_MB-------------------- -------------------- ------------TEMP 16-JUN-2022 08:24:00 117TEMP 16-JUN-2022 08:25:00 120TEMP 16-JUN-2022 08:26:00 659TEMP 16-JUN-2022 08:27:00 2,985TEMP 16-JUN-2022 08:28:00 4,328TEMP 16-JUN-2022 08:29:00 5,477TEMP 16-JUN-2022 08:30:00 6,772TEMP 16-JUN-2022 08:31:00 8,119TEMP 16-JUN-2022 08:32:00 10,196TEMP 16-JUN-2022 08:33:00 11,801TEMP 16-JUN-2022 08:34:00 13,227TEMP 16-JUN-2022 08:35:00 14,150TEMP 16-JUN-2022 08:36:00 15,622TEMP 16-JUN-2022 08:37:00 18,047TEMP 16-JUN-2022 08:38:00 19,314TEMP 16-JUN-2022 08:39:00 20,390TEMP 16-JUN-2022 08:40:00 21,277TEMP 16-JUN-2022 08:41:00 22,286TEMP 16-JUN-2022 08:42:00 23,234TEMP 16-JUN-2022 08:43:00 25,367TEMP 16-JUN-2022 08:44:00 27,064TEMP 16-JUN-2022 08:45:00 28,358TEMP 16-JUN-2022 08:46:00 29,674TEMP 16-JUN-2022 08:47:00 30,768TEMP 16-JUN-2022 08:48:00 31,967TEMP 16-JUN-2022 08:49:00 32,702TEMP 16-JUN-2022 08:50:00 182TEMP 16-JUN-2022 08:51:00 202

Historical TEMP Tablespace Usage By Session

AWR/ASH

Bibliography

http://www.orafaq.com/node/2https://stackoverflow.com/questions/174727/discover-what-process-query-is-using-oracle-temp-tablespacehttps://confluence.atlassian.com/confkb/oracle-temp-tablespace-keeps-on-increasing-on-oracle-11g-and-12c-899547856.htmlhttps://orahow.com/checking-temporary-tablespace-usage/https://paulstuartoracle.wordpress.com/2014/07/20/analysing-temp-space-usage-with-ash-data/