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.

Heart of Darkness

I had heard tales of its existence. A dark, soul-less being whose only purpose in this world was to cause pain and misery. It strikes without warning and without prejudice. By the time your eyes come upon it, it is already too late. It has but one name, and few... [Read More]

Caveats for renaming a server running ASM

I have a small tower running Oracle 10.2.0.3 on CentOS4 under my desk that I use as a personal sandbox for playing with Oracle so I'm not always futzing with developer instances. This was where I first played with ASM, etc. However, I rarely actually use this machine from day-to-day.Recently,... [Read More]
Tags: ocr asm oracle