Re: TEMP space in Oracle 817

this is the script i wrote a couple of years ago....

select A.tablespace_name,A.tot_mb,B.cached_mb,B.used_mb from
(select tablespace_name,

   sum(user_bytes)/1024/1024 tot_mb
from dba_temp_files
group by tablespace_name) A,
(select tablespace_name,

   sum(BYTES_CACHED)/1024/1024 cached_mb ,    sum(BYTES_USED)/1024/1024 used_mb
from v$temp_extent_pool
group by tablespace_name) B
where a.tablespace_name=b.tablespace_name

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, April 24, 2003 12:36 AM

> Hi all:
>
> How would one monitor a TEMP space in Oracle8.
> One of our reports failed complaining that it ran out
> of space in TEMP. For a regular TS I could look at
> dba_free_space to check for fragmentation, but I can't
> do it for a TEMP (afaik). What info can I get from
> Oracle to point me to a right direction? Any ideas?
>
> thanks
>
> Gene
>
> __________________________________________________
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo
> http://search.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Gurelei
> INET: gurelei_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: rahul sharma
  INET: rahul_at_infotech.co.id

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).