Database Administration (MOSC)

MOSC Banner

Health Check - temoprary tabblespace

edited May 14, 2012 2:32AM in Database Administration (MOSC) 5 commentsAnswered
Hi all,
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.

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