Too many rows in V$TEMP_SPACE_HEADER?
Hi,
I am running Oracle 19.10/19.11 Database Enterprise Edition on Linux (SLES15) and for internal monitoring I am using V$TEMP_SPACE_HEADER to retrieve the usage of the TEMP tablespace. Not sure since when this happens but currently I get in my CDB:
set linesize 180
col TABLESPACE_NAME format 999
col FILE_ID format 999
col BYTES_USED format 999,999,999,999
col BYTES_FREE format 999,999,999,999
col CON_ID format 999999
select CON_ID, TABLESPACE_NAME, FILE_ID, BYTES_USED, BYTES_FREE from V$TEMP_SPACE_HEADER order by con_id, file_id;
CON_ID TABLESPACE_NAME FILE_ID BYTES_USED BYTES_FREE
------- ------------------------------ ------- ---------------- ----------------