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

Thread: Who is using the TEMPORAL tablespace?

  1. #1
    Join Date
    Sep 2000
    Posts
    20
    Is there any way I can tell which user is generating the segments in the tablespace TEMP?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    look v$sort_usage

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Do you know that before 9i the USER column shows SYS regarless of the actual user? (ref: Metalink note 67534.1)

    Is it probably because the developers at Oracle have used the reserved word USER instead of USERNAME (which is used in 9i).
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Jan 2002
    Posts
    146
    hi,

    Will this do also for RBS? Is there a v$ view for both?

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by rommel
    hi,

    Will this do also for RBS? Is there a v$ view for both?
    To find out which user is accessing a RBS run:

    Code:
    select v.sid, v.username, t.xidusn, t.ses_addr, r.segment_id, r.segment_name 
    from v$session v, v$transaction t, dba_rollback_segs r 
    where v.saddr = t.ses_addr and t.xidusn = r.segment_id;
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  6. #6
    Join Date
    Jan 2002
    Posts
    146
    Thank you Julian,

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