Re: Rollback segment space usage

[Mohammad Rafiq]

George,

Try this query and check for average_active


select ud.name,
sg.extents ext,
round(sg.blocks * ts.blocksize / 1048576, 2) MB,
round(s.optsize / 1048576, 1) optsize,
round(s.aveactive / 1048576, 1) AVEACT,
round(s.hwmsize / 1048576, 1) HWMSIZE,
s.shrinks,
s.wraps,
s.waits,
nvl(s.status, 'OFFLINE') status
from v$rollstat s,
sys.undo$ ud,
sys.seg$ sg,
sys.ts$ ts
where ud.us# = s.usn (+)
and ud.file# = sg.file#
and ud.block# = sg.block#
and sg.ts# = ts.ts#
/

Regards
Rafiq





Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 23 Oct 2002 09:02:17 -0800

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).


_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohammad Rafiq
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).