-
How do I find what transactions (SQL Statement, USER) are accessing a ROLLBACK Segment?
Thanks,
Keith
-
use some variation of
select s.sid, s.osuser, s.username,r.usn, r.name rollback_seg, t.used_ublk,
stat.rssize/blocksize RBS_BLKS
from v$session s, v$transaction t, v$rollname r, v$rollstat stat
, (select bytes/blocks blocksize from sys.dba_segments where rownum=1)
where s.taddr(+) =t.addr and t.xidusn(+) = r.usn and r.usn = stat.usn(+)
order by r.name;
(Oracle 8i)
d.
p.s. you could also use
(select value blocksize from v$parameter where name ='db_block_size')
to get the blocksize instead of using sys.dba_segments in-line query.
[Edited by DBAtrix on 02-12-2001 at 11:10 AM]
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
|