Quick Review of Oracle on CentOS (RHEL) 5

Hampus Linden, the Swedish werewolf in London, has posted a light review of Oracle on CentOS 5, the latest release to match the new RedHat Enterprise Linux 5. CentOS is basically RHEL without the paid support, great for testing/development environments.

SQL for the Childrens

Gary "Igore" Myers, upon hearing the glad tidings of Pete Finnigan's parental status, has produced a handy (if not a bit cheeky) SQL primer for the kids. Maybe I can teach my 21-year-old brother-in-law some SQL now as well.
Tags: children sql

sprintf() in PL/SQL

René Nyffenegger has hacked up a PL/SQL implementation of sprintf(). I haven't done too much in PL/SQL, but I didn't have much a problem with lpad() and rpad(). But who doesn't love good old sprintf() otherwise?

Christo on Aligning ASM Disks on Linux

As I sit here on a Sunday morning waiting for some disk issues to be resolved in my datacenter, I took the time to catch up on some pages I had marked for later reading. One was a post by Christo Kutrovsky from the Pythian Group, about aligning ASM disks... [Read More]
Tags: asm oracle i/o

Optimizing through Understanding

Early last month Jonathan Lewis put up a great web presentation called "Optimizing through Understanding." I only just got around to viewing it, and it's packed with good stuff on breaking down queries and rewriting queries to find and hint for the best query plans available.