Ref:(Who is using temp table space)

Hi,

Can any one help to find out which user is using temp tablespce.

In the DBA Studio I can see the dependencies, but I do not know the sql script how to get those users.


Thanks,

In oracle 8, you can see who uses sort segments with :

SELECT username, sid, serial#, contents
FROM v$session, v$sort_usage
WHERE v$session.saddr = v$sort_usage.session_addr

In oracle 7 it's a bit longer, I'll post only if needed :D