Database Administration (MOSC)

MOSC Banner

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

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

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