RE: TEMP tablespace - objects in

From: Trassens Christian <trassenc_at_TELEFONICA.COM.AR>
Date: Wed, 28 Jun 2000 20:30:25 -0300
Message-Id: <10542.110726@fatcity.com>

I forgot to say that there a long script in the Metalink that gives you = the
user or users using the TEMP tablespace. I don't remember the note id. However there is another way when you query the v$session_wait where = event
is a 'db sequential read' in the datafile/s of TEMP. The problem of = this is
that you can only get the sid of session only when is doing the sort = over
the temp tablespace.

Regards.

> -----Mensaje original-----
> De: Trassens Christian [SMTP:trassenc_at_telefonica.com.ar]
> Enviado el: Mi=E9rcoles 28 de Junio de 2000 19:26
> Para: Multiple recipients of list ORACLE-L
> Asunto: RE: TEMP tablespace - objects in=20

>=20

> v$sort_usage is a Oracle 8 view.

>=20

> Regards.

>=20


> > -----Mensaje original-----

> > De:	John Barron [SMTP:jbarron_at_windriver.com]

> > Enviado el:	Mi=E9rcoles 28 de Junio de 2000 14:57

> > Para:	Multiple recipients of list ORACLE-L

> > Asunto:	TEMP tablespace - objects in=20

> >=20

> > Hi

> >=20
> > Im trying to find what objects are filling up our temp ts using =
this sql
> > on a 734 db but it returns the error:
> >=20
> > from v$session s, v$sort_usage u
> > *
> > ERROR at line 3:
> > ORA-00942: table or view does not exist
> >=20
> > Any ideas. I got the sql from the list - cant remeber who. Full sql
> below.
> >=20
> > Ive looked at the objects in the temp ts using dbartisan and there =
is
> just
> > one - SYS.8.21107 occupying 999M in our IG temp ts.
> >=20
> > John
> >=20
> >=20
> > select s.username, u."USER", u.tablespace,
> > u.contents, u.extents, u.blocks
> > from v$session s, v$sort_usage u
> > where s.addr =3D u.session_addr;
> >=20
> --=20
> Author: Trassens Christian
> INET: trassenc_at_TELEFONICA.COM.AR

>=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).
Received on Wed Jun 28 2000 - 18:30:25 CDT