Re: Who is using temp tablespace?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 1997/05/25
Message-ID: <01bc68e8$aacca150$294b989e@WORKSTATION>#1/1

You could try running queries against v$session_wait for

	event like 'db file%^read' 
and	p1 in (list of file ids for temp tablespace files)

This is likely to give some indication of a user that is hitting the files a lot.

EAL <asn_at_spot.Colorado.EDU> wrote in article <5lqpfd$mvo_at_lace.colorado.edu>...
> Hi netters. We have big jobs sorting in the temp tablespace. Is
there any
> way to determine which jog or which user is using the temp
tablespace?
> We did query on dba_segments and could not get what we want.
>
> TIA.
>
Received on Sun May 25 1997 - 00:00:00 CDT