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 9,600 MB scale). The OLTP workloads consisted of 60 percent reads and 40 percent writes.
For the OLAP workload tests, we used Swingbench 2.5, 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 12c 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.