Health Check - temoprary tabblespace
I just try to make a database health check on Database 10.1.0.5, running on Solaris10,
by using the description in the following note: How to Perform a Health Check on the Database [ID 122669.1]
After running some scripts from chapter "6.4 Temporary Tablespace", I'm a little confused.
The result of statement
SQL> SELECT TABLESPACE_NAME, CONTENTS FROM DBA_TABLESPACES;
includes the following row:
TABLESPACE_NAME CONTENTS
===========================
TEMP TEMPORARY
The result is right, we have one temporary tablespace with one datafile.
The size of the datafile has currently about 7 GB, and it seems that 21 % are in use.
I run the next statement, which should give the size of the temporary tablespace.