Re: unlimited_rollback_segments init parm?

Rick Papaj said >>>
With 7.3.3, I hit errors "ORA-01681: Parameter unlimited_rollback_segments must be set to TRUE for this operation" & "ORA-02226: invalid MAXEXTENTS value" when attempting to set maxextents to unlimited for rollback segments.

Will this parameter solve my problem? <<<,

I think that before resorting to using an undocumented parameter to solve your problem that it would be better to tune your existing rollback segments first. You did not list your current rollback segment parameters, but since you are running into max extents then I suggest you consider:

1. Resizing your existing extents
2. Checking on your average transactions to rbs segment count for how many you need
3. if only one job is getting the 'max extents error' then allocating a large segment and using the 'set transaction use rollback segment roll_name' command
4. Verify that you have enough total rbs space allocated to begin with

I do not think that allowing a transaction of (in theory) unlimited size is a good idea since you will run out of rbs tablespace before you run out of extents by using the unlimited_rollback_segments parameter.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Sun Sep 27 1998 - 11:48:49 CDT