Database Administration (MOSC)

MOSC Banner

AWR IO Stat data missing for TEMP tablespace after recreating the tablespace

edited Dec 23, 2013 1:32AM in Database Administration (MOSC) 5 commentsAnswered
 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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center