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

On 16 Jun 2004 11:24:29 -0700, pinamati_at_yahoo.com (Pradeep Inamati) wrote:

>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.

Well, the first thing I see is your first query is returning bytes, and you're showing pct utilized from OEM. Could it be that 5925502976 bytes = 99% of your temp TS?

BTW, 99% utilized on TEMP is what you want to see. Oracle is managing it all internally. Received on Wed Jun 16 2004 - 15:36:42 CDT