Re: who is using sort space?

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_at_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_at_inconnect.com
http://www.inconnect.com/~kamradt/resume.html