Category Archives: Oracle

Wayback Machine: snapshots still valid technique

Posted on May 10, 2010 by kgorman

I came across this old article I wrote for the NOCOUG newsletter in 2002 about using OS snapshots for backups. This technique is still very much a valid and widely used technique to perform backups. The idea is simple: – … Continue reading →

Posted in Database Engineering, Mongodb, Oracle, PostgreSQL | Tagged , , , | View Comments

Dropping ACID

Posted on March 15, 2010 by kgorman

The de-facto durability story in MongoDB is essentially… there is none. Or at least single server durability. OMFG! No ACID WTF! &^%#^#?! For the next generation of internet scale, downtime intolerant systems, ACID may not be a desirable property. Traditional … Continue reading →

Posted in Data Architecture, Database Engineering, Mongodb, MySQL, Oracle | Tagged , , , , , , , , | View Comments

Backing up Oracle optimizer statistics

Posted on March 9, 2008 by kgorman

Oracle 10g has some neat features for keeping track of old statistics. Pre-10g It used to be important to backup your statistics before you analyzed a table just in case your plans went crazy. Now Oracle does this for you … Continue reading →

Posted in Oracle | Tagged | View Comments

Performance Tuning: Be Proactive

Posted on June 9, 2006 by kgorman

I see many articles out there talking about performance tuning using the Oracle waits interface. While I am not contending that technique; I believe it to be sound, and use this technique every day. What I am saying, is performance … Continue reading →

Posted in Oracle | Tagged | View Comments

Using Statspack Effectively

Posted on May 9, 2006 by kgorman

Statspack has been around since Oracle 8.1.5 and many DBAs regularly use it to diagnose and troubleshoot problems. Most of the time the stock report ($ORACLE_HOME/rdbms/admin/spreport.sql) is what is used. While good, this report only shows a snapshot of the … Continue reading →

Posted in Oracle | Tagged , , | View Comments