It's an SGA Explosion!

So now that I have an instance riding on some 64-bit hardware, I decided that it's time to raise the SGA. On our current 32-bit production and development machines, we have it set to roughly 1.5 GB, and the maximum SGA for 32-bit is roughly 1.75 GB. However with 64-bit... [Read More]

Fight the Lockdown

It's come up before, but it had been so long that I had nearly forgotten it. "It" is the serious permissions lockdown after installing Oracle RDBMS >= 9i. Someone brought it up on the MADLUG list earlier this year, and I vaguely remembered that it was fixed in Oracle 10g... [Read More]

Dynamic Listener Registration

By now I'm sure you all know that the Oracle listener supports dynamic registration, wherein Oracle RDBMS and ASM instances can automatically register themselves to the listener. You don't even need to have a listener.ora file (unless you need more than the default service/SID registered).However be aware that if the... [Read More]

asmcmd: command-line tool for ASM

I received a HOT tip yesterday about the existence of asmcmd. Frankly I'm ashamed that I didn't know about it sooner, since I've been doing an ass-ton of reading about ASM over the past month or so. I'd commit seppuku but I don't have a trusty second available. Instead, I'll... [Read More]