Re: unlimited_rollback_segments init parm?

The unlimited rollback segments init.ora parameter allow you to set the max extents storage clause for rollback segements to a value greater that the default defined by block size (2k : 121, 4K 256,.....). It will thus allow you to set it to unlimited.

BUT !!! I would NEVER recommend setting any object to unlimited extents, performance usually starts degrading after 20 or so extents and it you end up with 10,000+ extents you will have to wait days to drop the objects (yes days). Also SMON gets in a tiz trying to perform clean ups.

If you really want to go past the defaults, then I find that 300 to 500 works reasonably.

Regards
David

Richard A Papaj wrote in message <360BF923.DE52D2B2_at_acsu.buffalo.edu>...
>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.
>
>I wanted to research the parameter before I set it to true but can't
>find any information on it. It appears to be one of those undocumented
>init parms.
>
>Will this parameter solve my problem? Are there any ramifications in
>setting it to true? And lastly, are there any official or unofficial
>sources of information on undocumented init parms? (maybe not, then
>they wouldn't be "undocumented", would they!)
>
>Thanks,
>Rick Papaj
>
Received on Sun Sep 27 1998 - 15:35:51 CDT