-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|