Author: user

Some features in this post require a Diagnostics Pack license. In the last part I described a locking scenario where the blocking session had only executed one SQL statement that was quick enough to avoid being sampled by ASH and is now inactive. As a result, there is no ASH data for the blocking session,… Continue reading Diagnosing Locking Problems using ASH – Part 3

Some features in this post require a Diagnostics Pack license. I tried the graphical approach to tracking down the root cause of a locking problem in the last part. Now let’s look at the underlying ASH data. I ran the same test after bouncing my test instance to start from a clean slate. So, here… Continue reading Diagnosing Locking Problems using ASH – Part 2

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