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.
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]
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.