Re: script to show who is using temp. tablespaces.

Brian Motzer <bmotzer_at_spacestar.com> writes:

>I've been contacting Oracle support about finding a script to display
>who is using up
>the temporary tablespace. They have replied that someone sent them the
>following
>script. They did state that it has not been tested. I have had some luck
>running
>it to show who is using the space but not how much space they are using.
 

>If you have better luck please email me.

Wow. I always thought my script that follows showed me whose using up the temporary space:

col segment_name format a15
col owner format a10
col tablespace_name format a10
col bytes format 999,999,999,999
col extents format 9,999

SELECT
  owner, segment_name, tablespace_name, bytes, extents FROM
  dba_segments
WHERE
  segment_type = 'TEMPORARY'
/

-- 
/(o\ Nathan D. Hughes
\o)/ nhughes_at_umich.edu