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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
