To simulate OLTP database workloads, we used Silly Little Oracle Benchmark (SLOB) tool version 2.4. Our test featured two users with one thread each, and a 1 TB SLOB data set (108 users x 9600 MB scale). The OLTP workloads were designed to comprise 60 percent reads and 40 percent writes.
For the OLAP workload tests, we used Swingbench 2.5. Swingbench is a free Java-based tool for generating database workloads using different benchmarks. For this test, we used the Swingbench Sales History benchmark for the OLAP workload testing. The Sales History benchmark is based on the sales history (SH) schema that ships with Oracle 11g/Oracle Database and is TPC-H like. We created a 2 TB testing dataset and generated read-only queries. We used two Secure Shell users against each OLAP production database, each running on a separate RAC node.