Last night in #oracle, someone new to Oracle had some confusion with the SYSDBA privilege. I proceeded to drop some science on him, but here's a basic primer:Only a user with the SYSDBA privilege can startup or shutdown an instance.The oracle OS user can "connect / as sysdba" without providing...
[Read More]
Honorable Mention
I had to do a triple-take when I actually saw my name in print in the latest Pythian LogBuffer post. Then I had to re-read again to see if it was positive or negative. It was just for my post linking to the SQL implementations page, but still fun.I was...
[Read More]
ASSM IS EVIL!!!!!!11
OK not really, but HJR wants you to take caution before assuming that ASSM is the second coming. You probably don't want to use it in your direct-path/append-insert bulk loaded warehouse environment.I'm running a hybrid on 10gR2, and hope to fully use ASM when we migrate to the new 64-bit...
[Read More]
Comparison of different SQL implementations
Another gem found off of the oracle-l list is this page, which offers a nice breakdown of the differences between the various RDBMS implementations (Oracle, Postgres, MySQL, etc.) in terms of their SQL implementations.
Interpreting Query Plans
Someone one the oracle-l list posted a link to a nice breakdown of everything about Oracle's "explain plan" output. Very nice read.