We are getting the following error in our alert log for a database where we
are doing some unusually large transactions:
Wed May 15 03:26:22 2002
Failure to extend rollback segment 27 because of 1581 condition
FULL status of rollback segment 27 set.
On Metalink I've found a couple of
Just tested this on 8.1.7.0.
alter rollback segment rbs0 storage(optimal null);
Rob Pegram
Oracle Certified DBA
SQL select segment_name, optsize
2 from dba_rollback_segs, v$rollstat
3 where usn=segment_id;
SEGMENT_NAME OPTSIZE
pegramrg@yaho To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
o.com cc:
Sent by: Subject: Re: Unsetting OPTIMAL