Re: Users reading from rollback segments

Since you cannot predict who might need to generate consistent reads from the RBS in the FUTURE, you cannot predict if you will cause ORA-01555 or not by shrinking.

Your best bet is to get rid of people bloating up RBSs by limiting their growth, and enforcing the use of smaller transactions. That way you won't have to shrink so much.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Tue, 26 Feb 2002, Glenn Travis wrote:



> Is there a way to tell if anyone is reading from the rollback


> segments?

> 

> I would like to manually issue 'alter rollback segment XXX shrink;',

> but do not want to do so if there are users reading read consistent

> data from the rollback space (thus giving them the ORA-01555 error).

> 

> Is there a way to check if the rollback segment is in use first?

> 

> Can I try to take it offline?  Will it fail if there is someone

> reading from it?


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.net

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