Re: TEMP space in Oracle 817

Though, if it's "new" oracle's temp tablespace based on "tempfile", then information is also in v$temp_extent_pool.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, April 23, 2003 2:51 PM

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.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).