Test Tools and Configuration

Oracle OLTP Workload

SLOB is an Oracle workload generator designed to stress test storage I/O capability, specifically for Oracle Databaseusing OLTP workload. SLOB is not a traditional transactional benchmark tool. It is used to validate performance of the storage subsystem without application contention.

 

SLOB and Database Configuration

  • Database VM with a 32GB SLOB schema
  • SLOB parameter UPDATE_PCT set to 100 to reflect very heavy I/O workload
  • Think Time was set 0 to hit database with maximum requests concurrently to generate extremely intensive batch workload
  • SLOB parameter SCALE for the workload set to 32GB with Oracle SGA set to 32GB
  • SLOB parameter REDO_STRESS for the workload set to HEAVY
  • SLOB parameter RUN_TIME set to 30 minutes

 

Detailed SLOB configuration is included in Appendix C: SLOB Configuration

Key Metrics Data Collection Tools

 

We used the following monitoring tools in this solution:

  • Oracle Automatic Workload Repository
    • (AWR) reports with Automatic Database Diagnostic Monitor (ADDM). AWR collects, processes, and maintains performance statistics for problem detection and self-tuning purposes for Oracle Database. This tool can generate reports for analyzing Oracle performance. ADDM analyzes data in AWRto identify potential performance bottlenecks. For each of the identified issues, it locates the root cause and provides recommendations for correcting the problem.Find more information on Oracle AWR here
  • Oracle dynamic performance (V$) views and Oracle Alert log to check for errors
  • Linux system activity report (SAR)
    • Linux SAR helps collect and evaluate a variety of information regarding system activity. With performance problems, SAR also permits retroactive analysis of the load values for various subsystems (CPUs, memory, disks, interrupts, network interfaces, and so on). Find more information on Linux SAR here

 

check-circle-line exclamation-circle-line close-line
Scroll to top icon