The use of sequence cache and separate table
spaces for
large tables can help you improve your system performance. Also, you
can set applicable page sizes and storage capacities to these table
spaces and cache memories for optimal performance.
Table spaces
A
database administrator can use
the following guidelines for table space page sizes. The administrator
then moves the tables that include the most record types and are the
most heavily used into table spaces with these page sizes:
Table 1. Guidelines
for table spaces page sizesPage
size |
Row size |
Column
count limit |
Maximum capacity (DMS table
space) |
4 KB |
4005 |
500 |
64 GB |
8
KB |
8101 |
1012 |
128 GB |
16
KB |
16293 |
1012 |
256 GB |
32
KB |
32677 |
1012 |
512 GB |
Separate
indexes from the data and place them into a different
table space. Use the Database Configuration application to move the
indexes. Also, separate large tables, such as Assets and Work Orders,
into their own table spaces for optimal performance.
Sequence
cache
Sequence caches are used to
automatically generate unique values in the database. These values
are typically used as identifiers for columns or rows. Set the maxseq
sequence for the rowstamps column to 500 because this column frequently
requires values. Set the cache size for all other sequences to 50.