Oracle TEMP Tablespace

CREATE, DROP, Autoextend
TEMP Tablespace in an Oracle Data Guard configuration

Default Temporary Tablespace

To show the Default Temporary Tablespace...

COLUMN property_value FORMAT a80

SELECT property_value

FROM database_properties

WHERE property_name='DEFAULT_TEMP_TABLESPACE';

Current Total Used/Free per TEMP Tablespace

Current TEMP Tablespace Usage by Session

Current Temp Tablespace Usage by Session with SQL_FULLTEXT

Peak TEMP Used Per Day

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

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