Database Administration (MOSC)

MOSC Banner

Temp tablespace issue.

edited Aug 17, 2010 2:49AM in Database Administration (MOSC) 1 commentAnswered
This is curious
SQL> l
 1  select tablespace_name, file_id, bytes_used, bytes_free
 2* from v$temp_space_header
SQL> /

TABLESPACE_NAME              FILE_ID BYTES_USED BYTES_FREE
------------------------- ---------- ---------- ----------
TEMP                               5    1048576 5367660544
TEMP                               1 5242880000          0
TEMP                               2 1048576000          0
TEMP                               3 5242880000          0
TEMP                               4 5242880000          0

SQL> SELECT * FROM dba_temp_free_space;

TABLESPACE_NAME           TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
TEMP                              22145925120  16778264576              22131507200

so the select from v$temp_space_header tells me there is 5GB free and the select from dba_temp_free_space tells me there is 21GB free.

Which one is right ?

Database 11.1.0.7 on HP UX itanium.

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