Please join me in encouraging Cary Millsap in making regular appearances on his new blog. Cary, my personal story – one of my first and most vivid memories of taking on a DBA role was when my mentor, Guy Arteau, bringing me a copy of your OFA paper with great awe and reverence and suggesting I study it carefully.Read More >
Well, Paul Vallee tagged me, and as I haven’t yet passed my probationary period I should probably answer the call…..Eight things about me that aren’t common knowledge:Read More >
n Stuffing Six Million Pages Down Google’s Throat, Tim O’Reilly brings up a point, and some questions. . . just how poorly the big search engines index small sites with large collections of data . . .But it’s worth thinking about absolute (and temporary) limits to the growth of Web 2.0. What constraints do we take for granted? What constraints are invisible to us? Read more.Read More >
The latest release of DBD::Oracle is now ready and can be found at: CPAN DBD::Oracle. It is a Perl module that works with the DBI module to provide access to Oracle databases. It is maintained by me, John Scoles as open source/free software, under the auspices of The Pythian Group.
The release has been fully tested with the latest version of DBI (1.601). A list of the changes and/or fixes in this release are included.
I try to do a decent job of advocating for caring about good backups and business continuity strategies in my 7 Deadly Habits article. But this one beats them all, have a look for yourself, it too funny.Read More >
I’ve been told that using NOT EXISTS in (Oracle) SQL is a bad idea, and that a way to overcome this problem is to collect the non-matching rows with an OUTER JOIN. So I decided to check if it is true.Read More >
In the era of consolidation, storage has not been left out. The impact of backup on normal database activity . . . batch processing in one database impacting transactional processing — these are two real life examples of the consequences of storage consolidation known to almost every DBA. Virtualization puts a new twist in consolidation, but storage virtualization methods are very under-developed compared to computing resource virtualization. Storage QoS and storage virtualization must necessarily be very closely-related areas with a lot of overlap.Read More >
The “sla” in mysqlsla stands for “statement log analyzer”. This does a much better job than mysqldumpslow of analyzing your slow query log. This is really good for weeding out pesky entries in the slow query log that you do not care about. In this case, I’m using –slow to read the slow query log at the filename specified, –flat to flatten all the text to lowercase (basically case-insensitive matching) and –sort at to sort by “average time”.Read More >
I’m going to present couple sessions at the Australian Oracle User Group Conference in Melbourne next week. It’s the first time I’m presenting Down Under and I’m looking forward to it, although I’m still not sure if I should start from the last slide and proceed backward. It seems like I will never finish this blog post so I will be brief now and simply hint you what you can find in the next one. Nuno Souto, aka Noons, was very kind to invite me to his place for a dinner, and I can tell you it was fantastic evening. But this is a topic for the next photo-blog. Stay tuned!Read More >