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