In my last blog entry I alluded to perhaps not being all that happy about Fibre Channel. Well, it's true. I have been having a love/hate relationship with Fibre Channel for the last ten years or so, and we have now decided to get a divorce. I just can't stand it any more!
James Morle's BlogRSS Feed
OK, this one might be contentious, but what the heck - somebody has to say it. Let's start with a question:
Raise your hand if you have a feeling, even a slight one, that storage arrays suck? Read the full article
I was recently looking into a storage-related performance problem at a customer site. The system was an Oracle 10.2.0.4/SLES 9 Linux system, Fibre Channel attached to an EMC DMX storage array. The DMX was replicated to a DR site using SRDF/S.
The problem was only really visible during the overnight batch runs, so AWR reports were the main source of information in diagnosis. In this case, they were more than sufficient, showing clear wait spikes for 'free buffer waits' and 'log file parallel write' during the problematic period. They were quite impressive, too - sixteen second latencies for some of the writes. Read the full article
This year at the UKOUG Conference in Birmingham, acceptance permitting, I will present the successor to my original Sane SAN whitepaper first penned in 2000. The initial paper was spectacularly well received, relatively speaking, mostly because disk storage at that time was very much a black box to DBAs and a great deal of mystique surrounded its operation. Well, nothing much has changed on that front, so I figured it was very much time to update/rewrite the paper for modern technology and trends and try to impose my occasionally humble opinion on the reader Read the full article
I'm sure many of you are already enlightened enough about the dangers of ratios and averages, the most famous blunder of all being the 'cache hit ratio'. It's not that all ratios and averages are useless, but it is surely the case that most are useless, and that all can be misleading. This posting is about an example of a misleading average, one that hides the truth from the reader unless they look elsewhere. Read the full article