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,
Printable View
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