Database Administration (MOSC)

MOSC Banner

Negative values in dba_temp_free_space

edited Dec 20, 2010 6:11AM in Database Administration (MOSC) 2 commentsAnswered ✓
  Free Space is not calculated correctly in this example:

SQL> select * from dba_temp_free_space;

TABLESPACE_NAME                TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
------------------------------ --------------- --------------- ----------
TEMP                                  32505856        32505856   31457280
TEMP_TABLE_TEMPORARY                  26279936           65536   26214400
TBS_T100                              32505856       -51380224   83886080

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