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


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 rollback segments for the Encyclopedia database are:

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.