Your Browser is Out of Date

Nytro.ai uses technology that works best in other browsers.
For a full experience use one of the browsers below
Reference Architecture Guide—Accelerate Oracle Database using Oracle TimesTen as an Application-Tier Cache
Executive summary Solution architecture and components overview Use cases, test methodologies, and results Conclusion References Appendix: Configuration details
Hardware and software configuration details
Operating system settings
Dell EMC storage volumes and settings
Oracle Database configuration
Oracle TimesTen Database settings
HLR benchmarking usage and application settings

Oracle TimesTen Database settings

Home > Workload Solutions > Oracle > Guides > Reference Architecture Guide—Accelerate Oracle Database using Oracle TimesTen as an Application-Tier Cache > Oracle TimesTen Database settings

Oracle TimesTen Database settings

  • We used the TimesTen In-Memory Database software version 18.1.4.9.0 in this study.

    The TimesTen database settings were as follows:

    [ODBC Data Sources]

    sampledb=TimesTen 18.1 Driver

    sampledbcs=TimesTen 18.1 Client Driver

    [sampledb]

    DataStore=/ttdb/db/sampledb

    PermSize=2818000

    # For 400M case PermSize=620000

    TempSize=16384

    LogBufMB=32768

    LogFileSize=32768

    ReplicationParallelism=8

    LogBufParallelism=16

    CacheAWTParallelism=31

    DatabaseCharacterSet=AL32UTF8

    ConnectionCharacterSet=AL32UTF8

    PrivateCommands=1

    CkptReadThreads=4

    ReplicationParallelismBufferMB=1024

    OracleNetServiceName=TTORACDB2

    WaitForConnect=0

    RecoveryThreads=16

    IncludeInCore=1

    [sampledbcs]

    TTC_SERVER_DSN=SAMPLEDB

    TTC_SERVER=r740xd-ttcache/6625

    ConnectionCharacterSet=AL32UTF8

    We determined the optimal values for some of these parameters, such as LogBufParallelism, ReplicationParallelism and CacheAWTParallelism, during the initial trial-and-error tuning runs.