This blog contains experience gained over the years of implementing (and de-implementing) large scale IT applications/software.

Negative Values in V$TEMP_SPACE_HEADER

Darryl Griffiths
Whilst trying to figure out a reliable method of monitoring temporary tablespace usage I came across this problem.

The v$temp_space_header bytes_used column was displaying negative values.

Metalink has document 467435.1 which states quite simply that in 10.2.0.3 and later, the temp file header(s) may have been corrupted.

The solution, drop and re-create the temp file.

Add Your Comment

* Indicates Required Field

Your email address will not be published.

*