Category: Uncategorized

I wanted to talk about a few of the bugs and patches you need to be aware of if you plan to use DBMS_STATS.COPY_TABLE_STATS. Believe me, when entering the world of stats on (sub-)partitioned objects, you had better be prepared to spend a lot of time on My Oracle Support and a little time applying… Continue reading Statistics on Partitioned Tables – Part 6c – COPY_TABLE_STATS – Bugs and Patches

When I first started blogging, most of the material came from issues that I’d run into and how they were solved but, as I’ve spent most of the last 7 months not logging in to anything much ;-), it occurred to me that another area which I haven’t used for a long time is what… Continue reading Recurring Conversations – Incremental Statistics (Part 1)

In three weeks time, I’ll be travelling to Manchester for Oak Table World UK 2013. Actually, in three weeks time I’ll be watching Roddy Frame reprise Aztec Camera’s debut album – High Land, Hard Rain – but the next morning I’ll be catching the train to Manchester to present “Cloudy Reality”. It’s a presentation about… Continue reading Oak Table World UK 2013

Despite others best attempts – “Just one more” – I managed yet another early-ish night and so by the morning I was in a better than expected state for my Oak Table World presentation at 9am. I certainly looked in a better state than Tim Gorman, but thanks to him for showing up! 😉 When… Continue reading OOW13 – Day 2 – Oak Table World in the Cloud

MondayNo drinking, an early night and a little work meant that the meeting with Graham the next morning went well and we were almost ready to go. Well, I had one more slide to do, but that was fine 😉 Demogrounds time, then, particularly to catch up with the OEM performance guys and 12c multi-tenancy… Continue reading OOW13 – Day 1 – During Presentations

Sunday Most presenters would tell you that there are two distinct phases to conferences that they’re attending. Before and after their presentations. It’s difficult to truly enjoy the conference experience when the presentations that you’ve yet to deliver are rattling around in your mind. The effect is magnified, of course, if you’re one of the… Continue reading OOW13 – Day 0 – Before presentations

One of the reasons why it’s taken a while to get around to the next 10053 trace file post (apart from the more human reasons I talked about here) is that I’d planned to show how 10053 trace files can show whether the CBO has used Global Statistics on Partitioned Tables or not, which is… Continue reading 10053 Trace Files – Global Stats on Partitioned Tables

I think it was Andy C who first mentioned to me that one of the golden rules of blogging was never to apologise or justify your reasons for not blogging. I guess it’s because so many people do it so often that it becomes tedious. But my blogging output has been so woeful in the… Continue reading Blogging

As I suggested in my last post, there’s at least one more reason that your long-running SQL statements might not appear in SQL Monitoring views (e.g. V$SQL_MONITOR) or the related OEM screens. When the developers at my current site started to use SQL Monitoring more often, they would occasionally contact me to ask why a… Continue reading Real-Time SQL Monitoring – Retention

If you’re interested in Oracle performance (or system performance in general) and you don’t know who Cary Millsap is then I’m surprised. If you’ve never read ‘Optimizing Oracle Performance‘, then I think you should. Most of all, and this isn’t to diminish Cary’s other work in any way, if you’ve never had the pleasure of… Continue reading Advert: Cary Millsap in London