Oracle by its nature performs far more I/O transactions than other applications. High latency or low throughput can result with significant I/O Wait resulting in poor database response times for end users.
Kaminario K2 SAN storage is the optimal solution for Oracle applications that are I/O bound and suffer from high I/O Wait. Kaminario K2’s superior performance, coupled with its high availability, is a compelling reason for companies to keep their most demanding production databases on the Kaminario K2.
The following is an example of Oracle Automatic Workload Repository (AWR) report taken before and after implementing Kaminario K2. Prior to Kaminario K2, I/O Wait is accounted for more than 85% of the total call time even though the latency of I/O operations was around 5 ms.
| Event | Waits | Time(s) | Avg Wait (ms) | % Total Call Time | Wait Class |
|---|---|---|---|---|---|
| db file sequential read | 13,140,639 | 82,815 | 6 |
80.9 | User I/O |
| CPU time | 10,176 | 8.6 | |||
| read by other sessions | 1,830,667 | 3,503 | 2 | 4.2 | User I/O |
| log file sync | 141,585 | 829 | 6 |
1.6 | Commit |
| db file parallel write | 504,113 | 605 | 1 | 1.4 | System I/0 |
By moving the database to Kaminario K2, an 11-fold improvement was experienced on the overall performance of the application:
| Event | Waits | Time(s) | Avg Wait (ms) | % Total Call Time | Wait Class |
|---|---|---|---|---|---|
| CPU time |
15,588 | 71.5 | |||
| db file sequential read |
12,500,735 | 5,000 | 0 | 18.5 | User I/O |
| db file parallel write | 611,288 | 151 | 0 |
2.7 | System I/O |
| log file sync | 309,385 | 279 | 1 | 1.52 | Commit |
| direct path read | 267,793 | 134 | 1 | 1.2 | User I/0 |
For each performance problem, Kaminario’s professional service engineers will recommend what part of the Oracle database will best benefit from moving to faster storage. Obviously each application is unique, but in general, we have seen significant benefits after placing the hottest database files, temporary space redo and undo segments.
Kaminario utilizes a simple process for evaluating performance issues and implementing the Kaminario solution to resolve them:
"We were looking for a storage solution with a reliable, high-availability architecture to handle our growing trade volume and improve our system utilization. The Kaminario K2 gave us the ability to process 150% more trading transactions while also freeing-up our system and storage resources. We see this as a huge benefit."
- Rafi Vasserman, General Manager and EVP of Traiana R&D
Go to the Kaminario Storage Performance Assessment to get more information on this process and example results.
Request the Accelerating SAP Performance and Scalability with Kaminario's K2-Hybrid White Paper.
