On the one hand, I regret the fact I seem to be posting a lot of links to other people’s work at the moment but I couldn’t let this one by, if only for those who don’t use OraNA or the like and might miss it.

The one consistent message I kept hearing from other attendees at Openworld this year was that a lot of sites seem to have run into performance problems when upgrading from 9i to 10g due to changes in the CBO and DBMS_STATS. Yes, there are some Oracle 9i databases out there, you know.

Via Laurent Schneider’s blog, it looks like 10.2.0.4 is out. I’ve just had a quick look on Metalink and unfortunately (but unsurprisingly) it doesn’t seem to be available for AIX just yet, just Linux, but it’s one we’ve been waiting for for a while, so it’s good to see the first signs.

One of the headline recommendations during the Real World Performance groups presentations at Openworld 2007 was to review your parameter files as part of your upgrade process. It sounds like simple common sense, but they suggested that inappropriate parameter settings that had been implemented during version 7 days for long forgotten reasons were often the root cause of performance problems on 9i or 10g databases that they were asked to investigate. One of their first actions was to review the parameters carefully and question them.

After my last post about SQL*Net message to client wait event I had a follow-up question about what’s the difference between SQL*Net message to client and SQL*Net more data to client wait events.

In a recent Oracle Forum thread a question came up how to use SQL*Net message to client wait events for measuring network latency between server and client. The answer is that you can’t use it for network latency measurements at all, due how TCP stack works and how Oracle uses it.

Just how popular is PL/SQL? And how many PL/SQL developers are there “out there”? These are surprisingly hard questions to answer. Officially and even unofficially, Oracle Corporation’s point people on PL/SQL do not have any idea (or refuse to say) how many PL/SQL developers there are.

I have so far avoided writing such pointer blog posts which only refer you to another article, but I have to do it with this one. Adrian Billington has written an excellent article on performance of Oracle 11g PL/SQL function result cache.