From: gatjiekkuachlul@gmail.com   
      
   On Thursday, April 9, 1998 at 9:00:00 AM UTC+2, Doug Carter wrote:   
   > Hi Saad,   
   > >Is there a way to find out what rollback segments   
   > >are being used by a session   
   > This is not exactly what you want - but the logic   
   > should be enough to point you in the right direction.   
   > The following displays session and rbs segment   
   > details for sessions with locks in a rollback   
   > segment.   
   > select l.sid,   
   > l.type,   
   > s.username,   
   > r.owner,   
   > r.segment_name,   
   > l.lmode,   
   > l.request,   
   > l.id1,   
   > l.id2   
   > from dba_rollback_segs r, v$lock l, v$session s   
   > where s.sid = l.sid   
   > and trunc (l.id1(+)/65536) = r.segment_id   
   > /   
   > I don't have a database handy - but you might   
   > be able to use v$resource as a source for id1.   
   > Cheers   
   > Doug Carter   
   > Database Administrator   
   > TUI Consulting   
   Dear Doug Carter,   
      
   I am Gatjiek Kuach, I am South Sudanese working with Telecommunication company   
   as Oracle Database Administrator, I have been given task by my boss to always    
   "Display database sessions using rollback segments" I have been trying many   
   queries from    
   different guys, it didn't work, but your script help me a lot with result that   
   I mostly need.    
      
   Thank so much for devoting your time with that script.   
   Respectfully,   
   Gatjiek Kuach   
   Database Administrator   
   Digitel Telecom.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)