How to download patches from My Oracle Support (MOS) directly to the server? This has bothered me since the ftp access was closed a few years ago. Of course, I’ve been given some options by Oracle, like, I could access…Read More >
This post relates to my previous writing on mining the AWR. I noticed that it’s very easy to misinterpret the DISK_READS_TOTAL and DISK_READS_DELTA columns in DBA_HIST_SQLSTAT. Let’s see what the documentation says: DISK_READS_TOTAL – Cumulative number of disk reads for…Read More >
This is the second article in a series about internals and performance of concurrent managers. In this post, we’ll take a look at three important settings that affect the performance of the concurrent managers: number of processes, “sleep seconds”, and “cache size”. This article might be a bit on the theoretical side, but it should provide a good understanding of how these settings actually affect the behavior and performance of concurrent managers.Read More >
This is the first article in a series about performance of concurrent processing. We’ll take a closer look at the internals of concurrent managers, the settings that affect their performance and the ways of diagnosing performance and configuration issues. Today we’ll start with an overview of the internal workflow of a concurrent manager process. Enjoy the reading!Read More >
If you’re like me and are a DBA in the UK with a penchant for MySQL or Oracle, you’ll know we have a smörgåsbord of conferences here next week. We’ve been waiting, and like buses two have come at once. We have the UK Oracle User Group Conference 2012, in Birmingham on 3rd – 5th December 2012, and the Percona Live London MySQL Conference running on 3rd – 4th December. Pythian will be speaking at both events.Read More >
A mere 5,018 minutes until the festivities start at the 2012 version of the UKOUG User Group Conference. The show is intense and hugely educational with some of the world’s finest in attendance and presenting. For us Pythian’ites the trek terminates on Wednesday evening with British football’s Manchester United. Keep a close eye out for RACAttack above the vendor forum. Pythian’s own Alex Gorbachev and others will help you attack the RAC. Not to be missed.Read More >
Andrew Moore and Ben Mildren return from Ottawa to Bristol to London all in the name of MySQLRead More >
For those of you attending UKOUG today, there is a healthy dose of Pythian presentations on tap this afternoon. Actually, you can do it wall to wall 2:30pm to 6:30pm if you like.Read More >
Welcome to Log Buffer, the weekly round up of news and happenings in the database world.Read More >
OpenSQL Camp will take place Saturday 22nd and Sunday 23rd of August, in St. Augustin, Germany, so it could do for a nice August getaway to Germany. It’s not really the biggest of cities, but then again, that is part of the charm, going to some small city and learning more about databases.
In case you do happen to be curious, feel free to check out the list of proposed sessions, although it is not complete, it does give a overview of what to expect.