From: Eric & Carole Kamradt <kamradt@inconnect.com>
Subject: Re: who is using sort space?
Date: 1997/08/08
Message-ID: <33EB0DF9.E4AF1A5F@inconnect.com>#1/1
References: <01bca377$22e37920$af0ba8c0@pc240smo.mbo.sds.intra>
To: Scott Overby <scott.overby@sdsdata.com>
X-Priority: 3 (Normal)
Organization: Internet Connect, Inc. -- http://www.inconnect.com	
Newsgroups: comp.databases.oracle.server



Sure -
  The 'Advanced Oracle Tuning and Administration' book by Oracle Press
says
on page 100-101.
"To see the temporary segments currently in use, query
DBA_SEGMENTS, as shown in the following listing.
   SELECT  * FROM DBA_SEGMENTS
    WHERE Segment_Type='TEMPORARY';
"

I hope this helps, good luck
Eric Kamradt


Scott Overby wrote:

> Is there anyway of determining what user is using up
> TEMP tablespace by large order by's?
>
> ====================================
> =====================================
> Scott Overby                    E-mail  scott.overby@sdsdata.com
> Sr. Systems Analyst             Phone   (414) 459-7999
> Strategic Data Systems          FAX     (414) 459-9123
> 615 Penn Ave.
> Sheboygan, WI 53082
> ===================
> =======================================================



--
Thanks for your time

Eric Kamradt
hm: (801) 567-0912
mailto: kamradt@inconnect.com
http://www.inconnect.com/~kamradt/resume.html