Re: Q How to find owner using tablespace temp

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Thu, 21 Jan 1999 08:15:54 -0800
Message-ID: <Pine.OSF.4.02.9901210808350.11791-100000@gonzo.wolfenet.com>

On 18 Jan 1999, Rod wrote:
>
> Look at the owner of the segments in the tablespace.

That won't work. Sort segments (like the ones typically in a temp tablespace) are all owned by SYS.

Someone posted a really great idea to figure this out a couple months ago. Figure out the file IDs for the datafiles that comprise the TEMP tablespace. Then watch v$session_wait, looking for someone performing actions like 'db file sequential read' on those datafiles (where v$session.p1 = <file_id>) That person is your disk sorter.

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah

> Roman Starek <starek_at_pluto.spsselib.hiedu.cz> wrote:
> >
> > I have problem with growing up tablespace temp. Is there any
> > way to find out which user is using tablespace temp ?
Received on Thu Jan 21 1999 - 10:15:54 CST