March 2003

The Specialist
Database News You Can UseMarch 2003
A monthly newsletter for Oracle users
from Database Specialists, a consulting firm
specializing in Oracle technology

Don’t Miss This! A New White Paper on Interpreting Wait Events

Boosting system performance has always been a hot topic. Couple that with the new theories on analyzing Oracle wait events, and you have a winning combination that will help you diagnose application and database performance problems. IOUG Live! 2003 Conference Reminder

Database Specialists consultants Roger Schrag and Terry Sutton have teamed up to document more examples of how Oracle’s wait event interface can be used to solve real-world problems. This information-packed white paper is full of real-life scenarios the authors faced while providing both onsite and remote DBA consulting services. The paper, entitled “More Examples of Interpreting Wait Events to Boost System Performance,” is a sequel to Roger Schrag’s 2002 paper on wait events. You may read the two white papers in either order. You’ll find them at

For more information about Database Specialists’ consulting services, see


Billed as “The education conference for Oracle users by Oracle users,” the International Oracle Users Group Conference (IOUG Live! 2003) takes place in Orlando, Florida from April 27 to May 1, 2003. Database Specialists consultants Roger Schrag and Terry Sutton will lead a session at the conference titled, “More Examples of Interpreting Wait Events to Boost System Performance.” This 90-minute session is a follow-up to Roger Schrag’s 2002 wait events session that was ranked in the top 10 of over 300 IOUG Live! presentations. For more information about this great educational opportunity and many other session topics, check out Oracle Tips from Jonathan Lewis


Jonathan Lewis, a well-known expert on Oracle technology and author of “Practical Oracle 8i – Building Efficient Databases,” has compiled many resources over the years and organized them on his own website. The text is cleverly written and the site is easy to navigate. Check out to view an index of a variety of topics related to Oracle technology including: More Unix on Windows

  • Monitoring and Tuning–The usual set of tools
  • Database Administration–How to make life easy for a DBA
  • The Physical Database–How physical implementation makes a difference
  • Oracle Features–A review of the available special features
  • The Parallel Query Option
  • Internals–Things Oracle does behind closed doors

There’s lots more, so be sure to do a little exploring!


Last month we reported on a package from AT&T Research called UWIN that provides a mechanism for building and running Unix applications on the Windows platform. This month we felt we should also mention Cygwin. Cygwin is part public domain, part GNU general public license. This means you can download and use Cygwin for free, subject to some limitations on commercial distribution. New Resources from NoCOUG

According to the website, Cygwin consists of two parts:

1. A DLL (cygwin1.dll) which acts as a Unix emulation layer providing substantial Unix API functionality.

2. A collection of tools, ported from Unix, which provide Unix/Linux look and feel.

You’ll find more information on Cygwin at


The Northern California Oracle Users Group had a successful Winter Conference hosted by Oracle Corporation on February 20, 2003. The day-long event was filled with sessions on interesting topics presented by popular speakers. Check out the NoCOUG website at to view and download the latest presentations on the following topics and more:

  • Managing Production Databases – Best Practices
  • Understanding the Impact of J2EE Applications on Relational Databases
  • Java Basics for PL/SQL Programmers
  • Top Tips for Oracle Designer


Leave a Reply

Your email address will not be published. Required fields are marked *