February 2002

The Specialist
Database News You Can Use

February 2002
A monthly newsletter for Oracle users
from Database Specialists, a consulting firm
specializing in Oracle technology
In this issue:

The Art of Tuning Oracle Using the Wait Event Interface

Roger Schrag’s brand new white paper called “Interpreting Wait Events to Boost System Performance” will help you get the most out of your tuning efforts. Compiled from real-life situations, this extensive paper will show you how to get to the root of performance problems and guide you toward improved response time and better throughput.

Because the Oracle database kernel maintains detailed statistics about how each Oracle process spends its time, it provides valuable information for performance tuning. You can access this information by querying v$ views and setting special tracing events. This “wait event interface” allows Oracle professionals to gain insights into how their databases and applications are behaving, and is extremely helpful in diagnosing application and database performance problems.

Download your copy of Roger Schrag’s white paper today at http://dbspecialists.wpengine.com/presentations.html.

NoCOUG Winter Conference Coming Up!

Don’t miss another great meeting planned for the Northern California Oracle Users Group! Oracle Corporation is hosting the group in its conference center in Redwood Shores on Thursday, February 21, and it’s not too late to RSVP.

In addition to technical sessions led by well-known presenters and authors in the Oracle arena, there will be a special “Oracle by Oracle” track where you can learn the latest on subjects like Real Application Clusters (RAC) and Oracle 9iAS. The keynote speaker will be none other than Ken “Dr. DBA” Jacobs presenting “Oracle9i Database Overview.” Jacobs is Oracle Corporation’s Vice President Product Strategy, Server Technologies.

Read about the sessions at the NoCOUG Winter Conference and RSVP online at http://www.nocoug.org/next.htm. See you there!
Database Forums Online

No matter how long you’ve been working with Oracle technology, there is always something to learn. And a great way to learn is with the help of fellow IT professionals. You’ll find some of them online at dBforums.com. On this site, you’ll find a variety of database forums, and Oracle is at the top of the list. There are also forums on topics such as perl, DBI, PL/SQL, and Unix shell scripting. Anyone can read the advice supplied by members in the forums, however, you’ll have to register to post your own comments.

See what’s available at http://www.dbforums.com.
Oracle OpenWorld Recap

At December’s Oracle OpenWorld in San Francisco, Database Specialists’ president Roger Schrag led a session on using XML with Oracle. Roger’s session was rated by attendees as one of the top 10% of over 250 presentations given. If you weren’t able to attend the conference, you can still find the white paper and accompanying slide show on the Database Specialists website at http://dbspecialists.wpengine.com/presentations.html.

Database Specialists also provided demos of Database Rx at Oracle OpenWorld. Database Rx is a secure automated monitoring and analysis tool for Oracle databases. It provides real-time notification of performance, stability and scalability issues before they compromise your database’s performance. You can read about Database Rx at http://dbspecialists.wpengine.com/database_rx.html and you can also log in as a guest user to check it out at http://dbrx.dbspecialists.com/guest.

Leave a Reply

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