Here's part two!
I just got permission from The UK Oracle Users Group to reproduce my article series on optimising scans in Oracle. Part One is available here, Part Two will follow shortly after, and then Part Three will be a few weeks away, following its publication in the magazine. Enjoy!
To use ASMlib or not to use ASMlib? That is the question. Or at least, that is a question that frequently crops up when I'm on consulting engagements with customers. I have personally changed my mind a couple of times on this exact question, and I'm currently sat with one leg on either side of [...]
This blog post is an introduction to a few posts that can be grouped together under the banner of 'System Architecture'. Specifically, I'm referring here to Oracle Database System Architecture, not system architecture in general nor 'Oracle architecture' in general, which is an ever-growing beast. In this series of posts, I will take at look [...]
Last week I had a lengthy post at oracle-l that tackles Calibrate IO, Short Stroking, Stripe size, UEK kernel, and ASM redundancy effect on IOPS Exadata which you can read here
followed by interesting exchange of tweets with Kevin Closson here (see 06/21-22 tweets) which I was replying in between games at UnderwaterHockey US Nationals 2012 which we won the championship for the B division I have my awesome photo with the medal here
While doing my high availability deep dive at Collaborate 12 few weeks ago, I stated that storage replication qualifies for the cold failover licensing rules (see slide #128). During collaborate I spoke to one person at Oracle who definitely knows the rules. Simon Haslam also reached out to me by email pointing out that things...
Dear Linux Hackers, Have we not finished changing the 'best' way to have persistent naming and security attributes for disk devices? Seriously, just when we thought it was great to put the "uid", "gid" and "mode" specifications for disk devices into /etc/multipath.conf, then it gets once again deprecated in favour of udev. This push and [...]
(Updated 04/04/12 to fix bug with large raw disk partitions) I need your help! One of the things that I have struggled to get data for in my storage research is the latency of the interface between server and storage device. It's easy to get numbers for the actual storage device, but the latency numbers [...]
It is human nature to draw from experiences to make sense of our surroundings. This holds true in life and performance tuning. A veteran systems administrator will typically tune a system different from an Oracle DBA. This is fine, but often what is obvious to one, is not to the other. It is sometimes necessary to take a step back to tune from another perspective.
I recently have ran across a few cases where a customer was tuning “Sorts” in the database by adding memory. Regardless of your prospective, every one knows memory is faster than disk; and the goal of any good tuner is to use as much in memory as possible. So, when it was noticed by the systems administrator that the “TEMP” disks for Oracle were doing a tremendous amount of IO, the answer was obvious right?
We've just booked the first European venue for the Understanding Storage Masterclass. I will be presenting the Masterclass on April 24/25 2012 at Prospero House in London, tickets are available HERE. I'm pretty excited to host this training session in my home country, and I hope to see you there!