Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Checking free space in TEMP tablespace

User_3ZQRHDec 23 2016 — edited Dec 25 2016

Hi,

I am using 11.2.0.3 version of Oracle on AIX server.

I have seen that even if the database is empty, there is no active session except the Oracle background users and few monitoring tool sessions, still I find the "BYTES_FREE" column of V$TEMP_SPACE_HEADER to be always 0. There is only one default temp tablespace when I checked with the query DATABASE_PROPERTIES where PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE'.

Can you please clear my doubt why I always see the BYTES_FREE as 0 in V$TEMP_SPACE_HEADER.I have seen the same in all the environments like Dev, Testing etc. I can assume the Production server to be busy always but even for empty/idle database like Development server at late nigh with no active session, still the "BYTES_FREE" is zero. Is it valid ?

Thanks in advance.

This post has been answered by John Thorton on Dec 23 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 22 2017

Added on Dec 23 2016

#general-database-discussions

4 comments

2,789 views