No temp tablespace in awr section tablespace io stats
Martina, August 29, 2023 - 8:55 am UTC
Hello, thank you for your answer. As we couldn't apply patch now execute and change only one tables level(WRH$_TEMPFILE) from ALL to TYPICAL and it is working. Now we see data for TEMP01 in AWR report in section "Tablespace IO Stats"
SQL> select TABLE_NAME,FLUSH_LEVEL_VAL FROM AWR_CDB_TABLE_SETTINGS WHERE TABLE_NAME='WRH$_DATAFILE';
TABLE_NAME FLUSH_LEVEL_VAL
------------------------------ --------------------------------
WRH$_DATAFILE TYPICAL
SQL> select TABLE_NAME,FLUSH_LEVEL_VAL FROM AWR_CDB_TABLE_SETTINGS WHERE TABLE_NAME='WRH$_FILESTATXS';
TABLE_NAME FLUSH_LEVEL_VAL
------------------------------ --------------------------------
WRH$_FILESTATXS TYPICAL
SQL> select TABLE_NAME,FLUSH_LEVEL_VAL FROM AWR_CDB_TABLE_SETTINGS WHERE TABLE_NAME='WRH$_TEMPSTATXS';
TABLE_NAME FLUSH_LEVEL_VAL
------------------------------ --------------------------------
WRH$_TEMPSTATXS TYPICAL
SQL> select TABLE_NAME,FLUSH_LEVEL_VAL FROM AWR_CDB_TABLE_SETTINGS WHERE TABLE_NAME='Tempfile Group';
TABLE_NAME FLUSH_LEVEL_VAL
------------------------------ --------------------------------
Tempfile Group TYPICAL
SQL> select TABLE_NAME,FLUSH_LEVEL_VAL FROM AWR_CDB_TABLE_SETTINGS WHERE TABLE_NAME='WRH$_TEMPFILE';
TABLE_NAME FLUSH_LEVEL_VAL
------------------------------ --------------------------------
WRH$_TEMPFILE TYPICAL
August 31, 2023 - 2:49 am UTC
Thanks for getting back to us with that info