Re: TEMP space in Oracle 817

From: Darrell Landrum <dlandrum_at_zalecorp.com>
Date: Wed, 23 Apr 2003 10:51:54 -0800
Message-ID: <F001.00587EA2.20030423105154@fatcity.com>

Give this a try...

tti "Sort utilization in TEMP tablespace" col "Timestamp" format a13
--col "Table Space" format a18

col "Users" format 9,999
col "Used MBs" format 999,999
col "Free MBs" format 999,999
col "Total MBs" format 9,999,999
col "Total Size" format 99,999,999
col "ROOM TO GROW" format 99,999,999
select to_char(sysdate,'DD-MON HH24:MI') "Timestamp",
--      b.tablespace_name "Table Space",
        b.current_users "Users",
        b.used_extents * 1 "Used MBs",
        b.free_extents * 1 "Free MBs",
        b.total_extents * 1 "Total MBs",
        sum(a.bytes/1024/1024) "Total Size",
        sum(a.bytes/1024/1024) - (b.used_extents * 1) "ROOM TO GROW"

 from v$sort_segment b, dba_temp_files a where a.tablespace_name = 'TEMP'
and a.tablespace_name = b.tablespace_name group by b.tablespace_name, b.current_users,

        b.used_extents, b.free_extents, b.total_extents /

>>> gurelei_at_yahoo.com 04/23/03 12:36PM >>>
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: Darrell Landrum
  INET: dlandrum_at_zalecorp.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).

Received on Wed Apr 23 2003 - 13:51:54 CDT