Monthly Archives: May 2006

The benefits of testing

Posted on May 9, 2006 by kgorman

I was recently involved on a problem for a critical production database that had slow response time for inserts. The batch job inserting was running at full tilt, and adding more processes (concurrency) was not helping. Ah, there must be … Continue reading →

Posted in Random | Tagged | View Comments

Using RSS readers as a craigslist query tool

Posted on May 9, 2006 by kgorman

I am looking for a used Ford Truck, and was struggling with how to keep up to date with various web postings because of the high demand and quick turnaround for Ford F250′s with Diesel engines. I was looking for … Continue reading →

Posted in Random | 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