Try selecting from v$sort_usage.
> -----Original Message-----
> From: paquette stephane [SMTP:stephane_paquette_at_YAHOO.COM]
> Sent: Wednesday, May 03, 2000 3:50 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Temp tablespace
>=20
> You can use this :=20
>=20
> select distinct
> b.sid,b.serial#,substr(b.username,1,8)USERNAME,b.process,
> =
substr(c.segment_name,1,8)SEGMENT_NAME,substr(b.osuser,1,7)OS_USER,subst=
r(
> b.machine,1,6)M_NAME,
> substr(b.program,1,12)PROGRAM
> from v$access a, v$session b,dba_segments c
> where c.owner=3D a.owner
> and a.sid =3D b.sid
> and b.status =3D 'ACTIVE'
> and c.segment_type =3D'TEMPORARY'
> /
>=20
>=20
> --- "Klavers, Richard" <R.Klavers_at_arbeidsbureau.nl> a
> =E9crit:
> > Hi,
> >=20
> > is there a way to see which user or process is
> > consuming the=20
> > TEMP tablespace?=20
> > The tablespace is created as a 'TEMPORARY'
> > tablespace.
> > I've looked in all kinds of documentation, and you
> > can find all sort of
> > things
> > about rollback segments and memory and so on, but
> > nothing is said
> > about the TEMP tablespace.
> >=20
> > Regards, Richard Klavers
> >=20
> > --=20
> > Author: Klavers, Richard
> > INET: R.Klavers_at_arbeidsbureau.nl
> >=20
> > Fat City Network Services -- (858) 538-5051 FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
> >=20
>=20
> =3D=3D=3D=3D=3D
> Stephane Paquette
> DBA Oracle
> stephane_paquette_at_yahoo.com
> spaquette_at_houra.fr
> (33) 01 53 93 06 50
>=20
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
> --=20
> Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D
> INET: stephane_paquette_at_yahoo.com
>=20
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing =
Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Wed May 03 2000 - 14:25:08 CDT
