RE: Query temp segments blank

From: <mkline1_at_comcast.net>
Date: Wed, 26 Nov 2003 09:04:34 -0800
Message-ID: <F001.005D7E7D.20031126090434@fatcity.com>

Below was the closest I got, but it still pretty much shows everything "empty" sort of. Guess it's okay, I'll monitor. This is a warehouse so it's hard to say. So close to the holidays, it's possible they aren't using a lot of temp.

set linesize 162
set pagesize 30

column tablespace_name format a15 heading "Tablespace|Name" column file_id format 99999 heading "File|Id" column bytes_used format 999,999,999,999,999 heading "Bytes Used" column blocks_used format 999,999,999,999,999 heading "Bytes Used" column bytes_free format 999,999,999,999,999 heading "Bytes Free" column blocks_free format 999,999,999,999,999 heading "Blocks Free" column relative_fno format 9,999 heading "R File|No" select * from sys.v_$temp_space_header
order by tablespace_name, file_id;

column extent_size format 999,999,999,999,999 heading "Extent Size"

column total_extents format 999,999,999,999,999 heading "Tot Extents"
column used_extents format 999,999,999,999,999 heading "Used Extents"
column free_extents format 999,999,999,999,999 heading "Free Extents"

select tablespace_name, extent_size, total_extents, used_extents, free_extents from v$sort_segment;

--

13308 Thornridge Ct
Midlothian, VA 23112
804-744-1545
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
  INET: mkline1_at_comcast.net

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 Nov 26 2003 - 11:04:34 CST