I’m a bit late with that “news” but I have the second article about Oracle 10g Grid Control Extensibility, published in Q3 2007 issue of IOUG SELECT Journal magazine. Few more words about my future plans.. At the end of September, I’ll be at Slovenian Oracle User Group Conference 2007, After SIOUG 2007, I’m planning to visit Laladia where newly renamed event Miracle Oracle Open World takes place, then off to the Australian Oracle User Group Conference 2007, and finally I’m heading to Birmingham for UKOUG 07. So this is it for 2007. I’m looking forward to see you on one of those events!
A short note to let everyone know that I’ll be heading to Dubai later today to participate in Pythian’s exhibit in the Business Solutions Hall. For those of you who haven’t heard of it, GITEX is like COMDEX for the Middle-East – it’s literally the third largest tradeshow in the world where COMDEX is #1 – and it’s big, really really big, like 120,000 attendees big. Hope to see you there!
Steve Karam, The Oracle Alchemist, saved the skin of a harried LB administrator this week (that would be me), stepping up at the last moment to edit and publish the 60th edition of Log Buffer, the weekly review of database blogs. Thank you, Steve!
Now with the 11g we all can start the new release — at least on Linux x86 — so naturally, I was curious to see whether I was just throwing sparks without having a fire. Query Result Cache was the first new feature that I put to the test, only to discover that you can spend more than two minutes waiting on… guess what?
There’s an interesting dynamic going on right now in the DBA world. MySQL’s growth and installed base, as a function of its size three or five years ago, is perhaps five if not ten times larger than it was. In 2002 when Pythian’s MySQL services launched, we took on the platform at the explicit request of an existing customer that was primarily an Oracle shop, but that was adopting MySQL for some bolt-on systems. Today, MySQL is our fastest-growing practice in terms of new customer acquisition. The point I want you to take away from that is simply this: there are about five to ten times more high-value environments running MySQL in the world today than there were three years ago.
The 59th edition of Log Buffer has been published by Chen Shapira on I’m just a simple DBA on a complex production system.
Recently, I was asked to take a look at a query processing part of a client’s application which had started to perform slowly after the application had a maintenance downtime. The idea behind the processing was quite simple.The trick was to add a (redundant) CASE PROCESSED WHEN 0 THEN MOD(SUBS_ID, 7) end expression into ORDER BY clause..In this post I show you how I came to this solution.
The 58th edition of Log Buffer, the weekly review of database blogs, has been published by Jay Pipes (a.k.a J.Pipes) of MySQL AB on Design, Develop, Discover, Define.
For those of you expecting your weekly dose of Log Buffer in this space, it has been unavoidably delayed. It will appear around 3PM Eastern Time today. Hang tight!
So what is SQL Performance Analyzer (SQLPA)? The DBMS_SQLPA package enables you to register and compare the statistics of several SQL query executions stored in an SQL Tuning Set (STS). With SQL Performance Analyzer, you can compare the executions of queries before and after you make some changes to your database. As you might guess, I’m going to illustrate this new feature in Oracle 11g with a simple example.