SELECT r.NAME, -- rbs name s.sid, s.serial#, s.username, s.machine, t.status, t.cr_get, -- consistent gets t.phy_io, -- physical IO t.used_ublk, -- Undo blocks used t.noundo, -- Is a noundo transaction SUBSTR (s.program, 1, 78) "COMMAND", s.username "DB User", t.start_time, s.sql_address "Address", s.sql_hash_value "Sql Hash" FROM sys.v_$session s, sys.v_$transaction t, sys.v_$rollname r WHERE t.addr = s.taddr AND t.xidusn = r.usn ORDER BY t.start_time
Try this. It shows the undo blocks used in the rollback segment. Plus some other variables for query usage. -----Original Message----- Sent: Wednesday, October 23, 2002 12:02 PM To: Multiple recipients of list ORACLE-L Hi all, Trying here now since have tried to find it online and build the query myself. I need to figure out how much space a user/session is using of a rollback segment. I got the queries to show which segment the user is attached to but need to know how much is being used (something like a fuel gauge). Any takers. George ________________________________________________ George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leonard, George INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
