Discrepancy between Free Temp Tablespace in Sql Query vs. Enterprise Manager

From: Pradeep Inamati <pinamati_at_yahoo.com>
Date: 16 Jun 2004 11:24:29 -0700
Message-ID: <ebdb7ec8.0406161024.1da78061@posting.google.com>

On my database, I perform the following SQL query to check the free TEMP tablespace :

select a.tablespace_name,(bytes - bytes_used) free_space from
(select TABLESPACE_NAME,sum(BYTES_USED) bytes_used from
v$temp_extent_pool group by TABLESPACE_NAME) a,
(select tablespace_name,sum(BYTES) bytes from v$temp_extent_map group
by tablespace_name) b
where a.TABLESPACE_NAME=b.TABLESPACE_NAME;

It returns with TEMP 5925502976 bytes.

However, when I check through Oracle Enterprise Manager it tells me that the TEMP tablespace is 99% utilized. Can anyone explain the discrepancy. Is my SQL incorrect ?

Thanks. Received on Wed Jun 16 2004 - 13:24:29 CDT