RE: TEMP tablespace - objects in

From: Trassens Christian <trassenc_at_TELEFONICA.COM.AR>
Date: Wed, 28 Jun 2000 18:19:57 -0300
Message-Id: <10542.110715@fatcity.com>

v$sort_usage is a Oracle 8 view.

Regards.

> -----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;
Received on Wed Jun 28 2000 - 16:19:57 CDT