DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Ref:(Who is using temp table space)

  1. #1
    Join Date
    Jul 2002
    Posts
    29

    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,

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    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
  •  


Click Here to Expand Forum to Full Width