I received an email asking for my help with a production query that was performing badly on an AWS server. Other DBAs had apparently created…
A database that had been migrated to AWS went live and was hitting serious performance problems three times every weekday. I was asked to investigate…
I was asked to investigate a problem with an application which was suddenly exhausting its connection pool. I looked at OEM: That looked interesting. Almost…
Investigation I was not directly asked to look at this, but I was included in an email trail so I took a look. This initially…
Why would performing an index fast full scan 430 times, reading 38MB and getting back 297 rows cause a query to take almost an hour?
However this is a rather unintelligible long alphanumeric string…
A quick look at the relevant statistics showed why there was such a significant difference
As you can see, all the waits are on obj# 0, but there is never any object with and object_id of 0
However, two days later whilst still eating my breakfast I was asked to join a conference call about a bigger problem
As there was a chap from the product looking over my shoulder at the time and I had confidently told him that the problem was…