Arup Nanda posted a great blog article about one of the most fundamental, yet misunderstood, behaviors of the Oracle database: the relationship of the COMMIT statement and buffer caches being flushed to disk. I plan to re-read this every day for month. This clip seems apropos:The article is titled "100... [Read More]
Back to Blogger!
With the recent announcement of Google Apps for Domains integration with the rest of the Google tools suite, I've decided to further simplify my life and run this blog on Google's blogger utility. I've been considering coming back for a while, given that Wordpress doesn't let me do everything I... [Read More]
Beware the /var/tmp/.oracle Hidden Directory!
NOTE: This post originally appeared on the Pythian blog.A few months ago, we had a test instance complaining that it couldn't write to ASM. This was an 220.127.116.11 single (non-RAC) instance on Oracle Enterprise Linux 5, using ASM for the storage. We first saw these errors in the alert log:ORA-15032:... [Read More]
Installing Oracle 11gR2 Enterprise Edition on Ubuntu 10.04 (Lucid Lynx)
Note: This post originally appeared on The Pythian Group blog.I recently reformatted my laptop with the latest Ubuntu LTS release, 10.04, aka Lucid Lynx. Since I like to have a native client installation as well as a portable sandbox server, I decided to install the latest version of Oracle EE,... [Read More]
Applying Oracle 11.2 April 2010 PSU for Single-Instance ASM and DBMS
Note: This post originally appeared at The Pythian Group blog.NOTE NOTE: Grid Infrastructure PSU 9343627 has since been revoked by Oracle, and replaced with a newer PSU. Do not apply PSU 9343627. I'm leaving this post up for educational purposes only.When news of the April 2010 PSU for Oracle 11.2... [Read More]