Oracle Performance – Full Table Scan

In previous posts, we have discussed different Oracle wait events and the performance improvements that will be seen with the Kaminario K2 system. In this post, I would like to discuss how such an improvement affects the execution of a query and ultimately the end user queries. Let’s look at a simple select count from…

Moving up the Stack: Understanding Oracle and Storage Performance – IV

This is the fourth blog out of a 6-blog series that discusses Oracle and storage performance. If you’re new to this series, please visit the first blog in this series Moving up the stack: Understanding Oracle and storage performance. Similar to direct path read, which was covered in the previous blog, the direct path read…

Moving up the Stack: Understanding Oracle and Storage Performance – III

This is the third blog out of a 6-blog series that discusses Oracle and storage performance. If you’re new to this series, please visit the first blog in this series Moving up the stack: Understanding Oracle and storage performance. In the prequels to this blog, we’ve covered the Oracle wait events db file sequential read…

Moving up the Stack: Understanding Oracle and Storage Performance – II

This is the second in a series of six blogs that discusses Oracle and storage performance. Blog 1: Moving up the stack: Understanding Oracle and storage performance In this post we will describe the second most common event that is evident when an Oracle database suffers from I/O waits: db file scattered read. The db file…

Moving up the Stack: Understanding Oracle and Storage Performance

As part of the Kaminario’s vision of Application Aware Storage, we have analyzed enormous amounts of workloads from hundreds of customers. When evaluating workloads of relational databases such as Oracle and SQL Server, combined with statistics from the database layer, we found that we can better serve database customers if the underlying storage could automatically…