Poor Autorefresh Performance

Poor autorefresh performance is usually the result of large autorefresh operations. Use the ttCacheAutorefreshStatsGet procedure to check the autorefresh duration and observe whether the status remains InProgress for a long time.

Factors that can cause large autorefresh operations include:

• Incremental Autorefresh Becomes Full Autorefresh

• Unresponsive TimesTen Database Degrades Autorefresh Performance

• Refresh of Autorefresh Cache Group Shows Excessive Wait on Resources

• Abnormally Large Change Log and Base Tables

• Fragmented Autorefresh Change Log Table Space

• Degradation in Performance When Autorefresh Interval Is Small

• Large autorefresh interval

• Large number of cache groups with the same interval

• High rate of changes to the Oracle database tables

• The number of generations of child tables in a cache group

• The number of rows in the cached Oracle database tables

• The size of the rows in the cached Oracle database tables

Enable an AUTOREFRESH trace to diagnose autorefresh performance problems. See AUTOREFRESH Tracing for information.