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 – db file sequential read

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…