TEMP tablespace - objects in

From: John Barron <jbarron_at_windriver.com>
Date: Wed, 28 Jun 2000 09:40:52 -0700
Message-Id: <10542.110678@fatcity.com>

--=====================_182596760==_.ALT

Content-Type: text/plain; charset="us-ascii"

Im trying to find what objects are filling up our temp ts using this sql on a 734 db but it returns the error:

from v$session s, v$sort_usage u

ERROR at line 3:
ORA-00942: table or view does not exist

Any ideas. I got the sql from the list - cant remeber who. Full sql below.

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.

John

select s.username, u."USER", u.tablespace,

u.contents, u.extents, u.blocks
from v$session s, v$sort_usage u
where s.addr = u.session_addr;

--=====================_182596760==_.ALT

Content-Type: text/html; charset="us-ascii"

<html>

Hi 
 

Im trying to find what objects are filling up our temp ts using this sql on a 734 db but it returns the error: 
 
from v$session s, v$sort_usage u 
                  * 
ERROR at line 3: 
ORA-00942: table or view does not exist 
 
Any ideas. I got the sql from the list - cant remeber who. Full
sql below. 
 

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. 
 

John 
 
 
select s.username, u."USER",
u.tablespace, 
       u.contents, u.extents, u.blocks 
from v$session s, v$sort_usage u 
where s.addr = u.session_addr; 
</html>
Received on Wed Jun 28 2000 - 11:40:52 CDT