Re: sum of rollback segments for any specific session

This will tell you which one they are using:

  SELECT username,s.machine,s.osuser,r.name   FROM v$transaction t, v$rollname r, v$session s   WHERE t.addr = s.taddr
  AND t.xidusn=r.usn;

v$transaction.USED_UBLK tells you how much undo is used. ----- Original Message -----
From: Charlie Mengler <charliem_at_mwh.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, October 18, 2000 3:26 PM Subject: sum of rollback segments for any specific session

> I'd like to be able to see/report how much rollback space
> any specific session is currently consuming.
>
> I have FOUR different Oracle manuals open on my desk
> and still can't see any way to link any particular
> RBS to any specific Oracle SID/SERIAL#. In this
> case I failed at RTFM or just have not found the
> right manual.
>
> If anyone knows how to do this, I'd appreciate it
> if they'd share their knowledge with me.
>
> TIA!
>
> --
> Charlie Mengler Maintenance Warehouse
> charliem_at_mwh.com 10641 Scripps Summit Ct
> 858-831-2229 San Diego, CA 92131
> Your call is important to us. Please continue to hold!
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Charlie Mengler
> INET: charliem_at_mwh.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Oct 18 2000 - 15:30:43 CDT