Provide Enough Memory

Performance impact: Large

Configure your system so that the entire database fits in main memory. The use of virtual memory substantially decreases performance.

The database or working set does not fit if a performance monitoring tool shows excessive paging or virtual memory activity. You may have to add physical memory or configure the system software to allow a large amount of shared memory to be allocated to your process(es).

For Linux systems, you must configure shared memory so that the maximum size of a shared memory segment is large enough to contain the size of the total shared memory segment for the database.

In TimesTen, the entire database resides in a single shared memory segment. Set the appropriate operating system kernel parameters for shmmax, shmall, memlock, and HugePages. See Operating System Prerequisites in the Oracle TimesTen In-Memory Database Installation, Migration, and Upgrade Guide

TimesTen includes the ttSize utility to help you estimate the size of tables in your database. For more information, see ttSize in the Oracle TimesTen In-Memory Database Reference.