Tag: Oracle IO testing

Batched Table Access

When I first saw the suffix BATCHED in an Oracle execution plan from 12c, I was curious to see what is hidden behind and how it works. I had some spare time for testing and wanted to share my findings…

Read More >

My First Experience Running SLOB – ORION vs SLOB – 2:0

This posts finalizes a few weeks of work on comparing SLOB and ORION IO testing tools.

Read More >

My First Experience Running SLOB – Final Results – ORION vs SLOB

In this blog post, I will share the physical IO testing results I got by running SLOB and ORION on the same system and on the same disks. I will use those results as a reference in a few blog posts to come. As of now, I would like to make few points based in the results here.

Read More >

My SLOB IO Testing Index

As SLOB takes the IO testing on Oracle Instance level, you need to watch for several things before you declare official testing results. My suggestion is: Don’t take any result for granted. You need to assess those before stating that you are done.

Read More >

My First Experience Running SLOB – Don’t Repeat My Errors (AWR)

If you are wondering what I have been busying myself with, this post explains it. As you may have noticed, I am still testing one of the Oracle systems using the SLOB framework and learning on my way. I ran several tests with the same parameters (Readers 24) and noticed that for one reason or another awr.txt reports different runtimes.
I was wondering why I was getting inconsistent runtimes for similar conditions. The answer to the mystery was very simple: The runit.sh script just generates awr.txt reports for the last and before last awr snapshots.

Read More >