Using Google Chrome?

Download my
free Chrome Extension, Power Notes Searcher, to make searching for and evaluating SAP notes, much easier.

Recent Posts

Thursday, April 12, 2012

Negative Values in V$TEMP_SPACE_HEADER

Print Friendly and PDF
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.

No comments: