Previous Topic: UNIX/Oracle Database Customization ProceduresNext Topic: Adjusting the init<Encyclopedia database name>.ora


Adjusting the Rollback Segments and Rollback Tablespace

If you have 20 - 25 users or more for the encyclopedia, you may want to add rollback segments and increase the size of the rollback tablespace. Also, if you are working with large models (more than 125,000 objects), you may want to increase the size of the rollback tablespace.

Multiple concurrent uploads create heavy activity. This can cause contention, which can degrade performance. If you plan to run multiple concurrent uploads, you need to increase the number of rollback segments and increase the size of the rollback tablespace. The following are the existing rollback segments for the Encyclopedia Database:

To add rollback segments, use the Oracle procedures for creating rollback segments.

Current rollback segments are placed in the tablespace:

iefsency_roll

To increase the size of the rollback segments tablespace, follow the procedures in Adjusting Database Size.