Best Practices for Operating System Configurations

This page contains recommendations for your Operating System configurations to achieve optimal performance in using the Oracle TimesTen product.

penguin
-
Use Memory Locking and large pages
-
Configure large OS TCP buffer windows
-
Configure sufficient number of OS semaphores
 

Use Memory Locking and Large Pages

Most operating systems provide the ability to specify memory locking to avoid paging of extended shared memory segments. When possible, consider using the MemoryLock attribute to specify that the TimesTen database extended shared memory segment should not be paged out.

Depending upon the Operating System you are using, you should look into enabling large page support either through your OS command or through the TimesTen daemon options file. For example,

On Linux, to enable large page support on TimesTen, add the following line in the TimesTen daemon options (ttendaemon.options) file:

    -linuxLargePageAlignment <Size_in_MB>

where the <Size_in_MB> is the Hugepagesize value in /proc/meminfo, specified in MB instead of KB.

On Solaris, setting the TimesTen First Connect attribute MemoryLock to a value of 3 or 4 also turns on the large page support.

Refer to the Oracle TimesTen In-Memory Database Installation Guide on MemoryLock setting and required permission.

Configure large OS TCP buffer windows

You should have your System Administrator look into configuring larger TCP send and receive buffer windows, particularly when you are using Replication.

Configure sufficient number of OS semaphores

You should review the Oracle TimesTen In-Memory Database Installation Guide to properly configure sufficient system semaphores, file system descriptors, large files, etc. to achieve optimal performance. System resource settings are platform specific, and thus should be set according to the platform where your TimesTen database is installed. The following are examples of system resources you should review and follow the recommendations in the Installation Guide::