Instruction Manual

Appendix B Database tips
• Change the % Increase to 10.
• Turn the Auto Extend ON.
• Change Initial to 1024 (KB).
• Check the Unlimited box.
• ROLLBACK Tablespace:
• Change the Size to 100 MB.
• Turn Auto Extend ON.
• Check the Unlimited box.
• INDEX Tablespace:
• Change the Size to 200 MB.
• Change the % Increase to 10.
• Turn the Auto Extend ON.
• Check the Unlimited box.
• TEMPORARY Tablespace:
• Change the Size to 250 MB.
• Change the % Increase to 10.
• Turn Auto Extend ON.
The following are recommended settings for the init.ora file:
• Add the following line after the control_files line.
rollback_segments = (SYSTEM, RB0, RB1, RB2, RB3, RB4,
RB5, RB6)
• Set db_block_buffers to 20000.
• Set sort_area_size to 2000000.
• Set sort_area_retained_size to 1000000.
266 Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014