Re: What is thelimit on Rollback Segment Size?

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.

Zdenka Spoljaric <928330N_at_KNOTES.KODAK.COM> wrote in message <3522812C.A6DBD58D_at_KNOTES.KODAK.COM>...
>The maximum size of a rollback segments is limited to the amount of space
>in the tablespaces' datafiles
>
>BADRI wrote:
>
>> Hi:
>>
>> What, if any, is the limit on the size of a rollback segment?
>> How large can the rollback tablespace itself be? If the OS does not
>> limit the size of the rollback tablespace, can the rollback segment
>> be as large as the tablespace?
>>
>> thanks a lot,
>>
>> -Badri
>
>
>
Received on Wed Apr 01 1998 - 00:00:00 CST