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.
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.
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.
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”.
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!
It recently came up that it would be helpful if we had a cheat sheet to find out the machine names for any given UNIX. I knew these off the top of my head but it would be great if people added more as comments.
I have recently stumbled upon V$SESSION_CONNECT_INFO view and discovered that it provides interesting information about client-side software and settings. Using this view in Oracle 11g you can simplify collecting some statistics about database clients. Here is what can be extracted.
The 11g platforms are now coming out fast and furious, In addition to the previously-released platforms.So download away, after checking your platform certification first, of course. Links to platforms in this post.
This is another tool in the same toolkit as archiver. I just saw a great blog post on it athttp://blog.arabx.com.au/?p=883. Documentation can be found athttp://mysqltoolkit.sourceforge.net/doc/mysql-checksum-filter.html. This is an invaluable tool for ensuring your replicated tables are staying in sync, something that MySQL replication does not do. Tables will drift and if you are dealing with…