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
Use cases, test methodologies, and results
HLR benchmark schema overview
HLR benchmark workload overview
Test methodology overview
Use Case 1: Small TimesTen cache on DRAM
Use Case 2: Large TimesTen cache on PMem
Conclusion References Appendix: Configuration details

Use cases, test methodologies, and results

Home > Workload Solutions > Oracle > Guides > Reference Architecture Guide—Accelerate Oracle Database using Oracle TimesTen as an Application-Tier Cache > Use cases, test methodologies, and results

Use cases, test methodologies, and results

  • The main goal of this study was to deploy TimesTen on a separate application server in front of a RAC database to offload processing of both queries and DML operations on a subset of dataset residing on the backend RAC database. During the workload tests, we wanted to measure the impact of TimesTen on the overall database performance and on the resource utilization of the RAC database.

    In order to measure the impact of using TimesTen as a database cache to a backend RAC database, we created two use cases:

    • Use Case 1: Small TimesTen cache on DRAM-only—In this use case the TimesTen server had system memory using DRAM-only modules. Only a relatively small subset of the RAC dataset was loaded into the TimesTen cache running on this DRAM-only configuration.
    • Use Case 2: Large TimesTen cache on PMem-MM—In this use case the TimesTen server had system memory using Intel PMem and DRAM (acted as front-end cache to PMem) modules. In general, with its larger capacity modules compared to DRAM modules, PMem enables loading larger RAC datasets into TimesTen within a single server when compared to DRAM-only configurations. In this study, PMem was configured to run in Memory Mode (PMem-MM) in the PowerEdge server’s BIOS.