My Oracle Support Banner

Duplicated Tempfiles Reported In View V_$TEMP_SPACE_HEADER And V_$Temp_extent_pool (Doc ID 2608014.1)

Last updated on DECEMBER 07, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 18.0.0.0 to 20.1 Preview [Release 18 to 20.0]
Information in this document applies to any platform.

Symptoms

Content for view v_$TEMP_SPACE_HEADER and v_$Temp_extent_pool are not correct

Problem Description
---------------------------------------------------

The content of the views v_$TEMP_SPACE_HEADER and v_$Temp_extent_pool are not correct.

Note: This behaviour can be also shown from OEM.

We have only one TEMP TABLESPACE with only one tempfile But, the views v_$TEMP_SPACE_HEADER and v_$Temp_extent_pool returns three lines

 

set linesize 200

select * from sys.v_$Temp_extent_pool

TABLESPACE_NAME FILE_ID EXTENTS_CACHED EXTENTS_USED BLOCKS_CACHED BLOCKS_USED BYTES_CACHED BYTES_USED RELATIVE_FNO CON_ID

------------------------------ ---------- -------------- ------------ ------------- ----------- ------------ ---------- ------------ ----------

TEMP 3 402 0 51456 0 421527552 0 1 3

TEMP 3 402 0 51456 0 421527552 0 1 3

TEMP 3 402 0 51456 0 421527552 0 1 3

set linesize 200

select * from v_$Temp_extent_pool

TABLESPACE_NAME FILE_ID EXTENTS_CACHED EXTENTS_USED BLOCKS_CACHED BLOCKS_USED BYTES_CACHED BYTES_USED RELATIVE_FNO CON_ID

------------------------------ ---------- -------------- ------------ ------------- ----------- ------------ ---------- ------------ ----------

TEMP 3 402 0 51456 0 421527552 0 1 3

TEMP 3 402 0 51456 0 421527552 0 1 3

TEMP 3 402 0 51456 0 421527552 0 1 3

set linesize 200

select * from dba_temp_files

FILE_NAME

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUTOEXTENSIBLE MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS SHARED INST_ID

---------- ------------------------------ ---------- ---------- ------- ------------ -------------- ---------- ---------- ------------ ---------- ----------- ------------- ----------

/oradata/orcl/temp01.dbf

3 TEMP 1.0845E+10 1323904 ONLINE 1 YES 3.4360E+10 4194302 128 1.0844E+10 1323776 SHARED

 



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.