Category: Oracle

Some features in this post require a Diagnostics Pack license. There are few better illustrations of the utility of ASH data than the ability to detect and diagnose locking problems*, even after they’ve occurred. Because ASH is sampling all active sessions all of the time, you should have information both for the blocked and blocking… Continue reading Diagnosing Locking Problems using ASH – Part 1

Toon Koppelaars is blogging. This should be good.

I love this article that I found via Greg Plavik’s blog. Not being a financial risk management expert means that I can’t claim whether it’s right or wrong, but I found it interesting. Why I mention it on this blog is that I spent almost the entire time reading it thinking that the writer could… Continue reading “People like to have one number they can believe in.”

Niall Litchfield made an interesting comment in an email thread that prompted this post. “… I can see that once you start to define workload, or transactions, in business terms (I need to get all these things done, what works best overall?) then workload response time* does make sense, both as a metric, and more… Continue reading Time Matters: Throughput vs. Response Time

I work at a site that has Diagnostic and Tuning Pack licenses (yippee!) so, before we started deploying Grid Control, I tried to encourage the installation of Database Control in the mean-time so that people could get used to the Performance Pages that I find incredibly useful. I was fascinated to see how my blind… Continue reading Grid Control Accessibility

Well, it worked last time, so I might as well try again 😉 My current contract runs out in 4 weeks time. Although there’s a likelihood that an extension will be on the table, nothing’s certain these days, so it makes sense to see if there are any other interesting opportunities out there. I’ve been… Continue reading Reverse Job Advert 2

This one’s been outstanding for a while. After my presentation on Audit Vault at UKOUG, the AV Product Manager Tammy Bednar sent me a couple of corrections to the configuration section. Rather than just amend the slides, I was keen to wait until I had another chance to configure a new source and collectors, which… Continue reading Adding a new Oracle host to Audit Vault

It’s that time of year again. As I think back to the past year with my Oracle-tinted glasses on, it all feels a little depressing for some reason, but I’m not sure why. Maybe it’ll become clearer as I look through the old posts. Actually, as a side-note, although I’ve often expressed my lack of… Continue reading 2007

I’ve been a bit busy recently because I’ve had a rolling 4 week cold (like lots of people in the office – obviously several colds in quick succession), a couple of presentations at UKOUG (where I’m sure the additional beer didn’t help recovery) and then I was in Vienna on Monday and Tuesday this week,… Continue reading Performance on my mind …

I woke up on the last full day of the conference with a couple of small things left to do on my second presentation. I was confident, though, because it was just a bit of tidying up. Mmmm, that turned out be a mistake 😉 First, though was Graham Wood’s “Cool Stuff with Hot ASHes”.… Continue reading UKOUG Days 4 and 5