IO

If you are using Oracle Database Appliance (ODA) then this patch is very important to apply. The patch bundle 2.1.0.3.0 has been published just this week and the most important fix from my perspective is the new BIOS version 12010304. Intel CPUs have a feature called Software Controlled Clock Modulation that allows programmatically control of [...]

Today I want to show what kind of IO performance we can get from Oracle Database Appliance (ODA). In this part, I will focus on hard disks. That’s right — those good old brown spinning disks. I often use Oracle ORION tool to stress-test an IO subsystem and find it’s limits. It’s a very simple [...]

Oracle 11.2.0.1 for Windows is out for some time. I’ve installed it on my 32-bit Windows XP machine because I like Windows – just to check that it’s actually working fine. Playing with TPC-H test using Hammerora I’ve noticed an anomaly in the way Oracle reports IO waits for some queries. Here is a test [...]