Rockwell Automation RSBizWare Administration Guide - Manual (Page 261)

Appendix B
Database tips
In this chapter you will learn about the following:
• Maintaining frequently used RSBizWare tables and indexes
(page 261)
• Using Oracle with RSBizWare (page 262)
There are certain RSBizWare database objects - tables and indexes -
that are frequently used by RSBizWare database views. The database
views are, in turn, used by most RSBizWare reports.
The frequent use of these database objects may result in the
following:
• Indexes can become fragmented.
• Log files can become very large.
• Tablespaces can fill up.
In order to prevent the report performance from degrading, the
following database maintenance should be performed on a regular
basis:
• Adding separate tablespaces.
• Partitioning.
• Adding additional data files.
• Purging older data.
Maintaining frequently used
RSBizWare tables and
indexes
Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014 261