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]
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]
ATTN Python Lovers: A New cx_Oracle Awaits You!
The Oracle extension of choice for python, cx_Oracle has come out with a new release. Release notes are fun reading, as always.For the unwashed masses (from their homepage):cx_Oracle is a Python extension module that allows access to Oracle databases and conforms to the Python database API specification.Makes me realize how... [Read More]