Re: who owns temp segments

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Mon, 15 Feb 1999 14:23:34 -0800
Message-ID: <Pine.OSF.4.02.9902151411390.3382-100000@gonzo.wolfenet.com>

> 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?

On Tue, 16 Feb 1999, Serge wrote:
>
> The same user who does sort or something else requiring sorting.

Actually, the sort segments are owned by SYS. For Oracle8, it was recently pointed out here that there is a fixed view called v$sort_usage that tells you who is sorting.

In Oracle7, if a user is sorting, you will see file I/O events in their entry in v$session_wait against the datafiles that constitute the TEMP tablespace.

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah Received on Mon Feb 15 1999 - 16:23:34 CST