AWR IO Stat data missing for TEMP tablespace after recreating the tablespace
We recreated the TEMP tablespace and now there's no IO Stat information in the AWR reports or dba_hist_tempstatxs view. See below sql we used to recreate the temp tablespace.
CREATE TEMPORARY TABLESPACE TEMP1
TEMPFILE '/oradata/dw/temp005/temp1.dbf' SIZE 512M AUTOEXTEND OFF;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP1;
DROP TABLESPACE TEMP INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
CREATE TEMPORARY TABLESPACE TEMP
TEMPFILE
'/oradata/dw/temp001/temp_01.dbf' SIZE 30440M,
'/oradata/dw/temp002/temp_02.dbf' SIZE 30440M,
'/oradata/dw/temp003/temp_03.dbf' SIZE 30440M,
'/oradata/dw/temp004/temp_04.dbf' SIZE 30440M,
'/oradata/dw/temp005/temp_05.dbf' SIZE 20G AUTOEXTEND OFF;
CREATE TEMPORARY TABLESPACE TEMP1
TEMPFILE '/oradata/dw/temp005/temp1.dbf' SIZE 512M AUTOEXTEND OFF;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP1;
DROP TABLESPACE TEMP INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
CREATE TEMPORARY TABLESPACE TEMP
TEMPFILE
'/oradata/dw/temp001/temp_01.dbf' SIZE 30440M,
'/oradata/dw/temp002/temp_02.dbf' SIZE 30440M,
'/oradata/dw/temp003/temp_03.dbf' SIZE 30440M,
'/oradata/dw/temp004/temp_04.dbf' SIZE 30440M,
'/oradata/dw/temp005/temp_05.dbf' SIZE 20G AUTOEXTEND OFF;
0