Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What is thelimit on Rollback Segment Size?
And as well, you don't necessarily want rollback segments with a single large extent..... and as of 7.x (7.2 and up for sure) the maxextents on a rollback segment can be specified as "unlimited" -- which really translates (with a db block size of 4K) to 2,147,483,645. I want to see someone extend a rollback segment that high! <G>
Rachel
Steve Phelan wrote:
> Er, and the storage settings and db blocksize:
>
> - initial, next (pct increase is always 0) and maxextents.
> - maxextents ultimate value based on db blocksize.
>
> Having said all the above, you can make very, very large rollback segments
> if you want (many Gig) as long as you have the disk space. Quite *why* you'd
> want to run transactions this big is another question! :-)
>
> Steve Phelan.
>
Received on Wed Apr 01 1998 - 00:00:00 CST