Title: Which rollback segment is currently active?
Hi,
If you
want to drop one of the the RBS, First you have to check in the application
level. Which user that used the rollback segment.
select
username,name,used_ublk,start_time,sum(waits),sum(gets),sum(waits)*100/sum(gets)from
Title: Which rollback segment is currently active?
Check
v$rollstat for xact 0.
-Original Message-From: Nguyen, David M
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 04, 2003 6:24
PMTo: Multiple recipients of list ORACLE-LSubject: Which
rollback segment is currently
David
This query will show sessions using rollback segments:
select s.username, s.sid, rn.name, rs.extents
,rs.status, t.used_ublk, t.used_urec
,do.object_name
fromv$transaction t
,v$session s
Title: Which rollback segment is currently active?
select rs.usn, xacts
active_transactions, gets, waits, writes, name from v$rollstat rs,
v$rollname rnwhere rs.usn = rn.usn
This
may help...
-Original Message-From: Nguyen, David M
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February