Re: Rollback Segments

From: Unisys <unisyshk_at_hknet.hk.net>
Date: Mon, 29 Nov 1993 07:33:03 GMT
Message-ID: <CH8sz5.C7w_at_news.hk.net>


You cannot do without any rollback segments at all. The least requirement is to have the SYSTEM rollback segment. I do not see how you can eliminate entirely the use of rollback segments. However, in version7.0 you can use the: ALTER ROLLBACK SEGMENT <<NAME>> OFFLINE; command to disable a RB. You can also drop a rollback segment altogether. Rollback segments can only be altered or dropped if they are not "IN USE". You can set aside a separate small tablespace for rollback segments and control its growth distinct from your data and index. Remember also that PUBLIC rollback segments are tough to get rid of so create all your rollback segments as private.

Regards,
S. Tedjarati
Unisys Hong Kong and China Limited
stedjara_at_unisys.hk.net Received on Mon Nov 29 1993 - 08:33:03 CET

Original text of this message