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