RE: Rollback and what table's DML caused an ORA-1555?

From: Jesse, Rich <Rich.Jesse_at_qtiworld.com>
Date: Mon, 07 Apr 2003 12:24:19 -0800
Message-ID: <F001.0057C35D.20030407122419@fatcity.com>

Thanks and <eeep!> I'll have to try this on a test database after I'm done messing with ^%@#% DBMS_STATS...

:)

Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_qtiworld.com           Quad/Tech International, Sussex, WI USA

-----Original Message-----
Sent: Monday, April 07, 2003 1:45 PM
To: ORACLE-L_at_fatcity.com
Cc: Jesse, Rich
Importance: High

Rich,

Reset optimal like this:

alter rollback segment <SEGMENT_NAME> storage ( optimal NULL )'

I sometime run a script to set optimal on all rbs segments, shrink the segments,
then reset optimal to null.

This has proven to be useful when it's known ahead of time that some large rbs eating operation is about to be take place.

Be forewarned: it can cause ORA-1555 on current queries.

Jared
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

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: 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 Mon Apr 07 2003 - 15:24:19 CDT