Saving Daylight for Oracle EM dbconsole

The big DST scare came and went and I thought I had gotten off scott-free. I ran Oracle's utility to determine if I had any timezone-sensitive data, and it reported that other than the GATHER_STATS_JOB, I don't. I didn't mind letting the stats gathering shift for an hour until I... [Read More]

40 Tips from Tom Kyte

Robert Vollman, via his oracleblog, offers a great list of 40 Tips from Tom, collected from just the articles updated this past week on AskTom. Definitely worth reading as well as following the links to the actual AskTom articles.P.S. -- Just in case you didn't know, "Tom" is Tom Kyte.... [Read More]
Tags: tkyte oracle

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]