System and Database Tuning

There are tips for tuning your system and databases.

• Provide Enough Memory

• Avoid Paging of the Memory Used by the Database

• Size Your Database Correctly

• Calculate Shared Memory Size for PL/SQL Runtime

• Set Appropriate Limit on the Number of Open Files

• Configure Log Buffer and Log File Size Parameters

• Avoid Connection Overhead for TimesTen Databases

• Load the Database Into RAM When Duplicating

• Prevent Reloading of the Database After Automatic Recovery Fails

• Reduce Contention

• Consider Special Options for Maintenance

• Check Your Driver

• Enable Tracing Only as Needed

• Use Metrics to Evaluate Performance

• Migrate Data with Character Set Conversions

• Use TimesTen Native Integer Data Types If Appropriate

• Configure the Checkpoint Files and Transaction Log Files to be on a Different Physical Device