Re: who owns temp segments

Use
select owner, segment_name, extents, bytes/1024 K from dba_segments
where segment_type = 'TEMPORARY';
and that will probably tell you what you need to know.

Hth,

Sybrand Bakker, Oracle DBA

doug_martin_at_cpr.ca wrote:

> Does anyone know how to tell who the user is that initiated a Sort that
> consumes specific temp segments in Oracle 7.3.4.3?
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Received on Mon Feb 15 1999 - 16:03:17 CST