October 2000

The Specialist
Database News You Can UseOctober 2000
A monthly newsletter for Oracle users
from Database Specialists, a consulting firm
specializing in Oracle technology
In this issue:SQL Tuning: Live and In Person

Last month, we announced a new white paper by Database Specialists’ founder Roger Schrag, entitled, “Use EXPLAIN PLAN and TKPROF To Tune Your Applications.” Over 300 people at Oracle OpenWorld attended Roger’s technical session of the same name.

We are pleased to present this session once again on Tuesday, November 14th, 2000 at Lockheed in Sunnyvale for the next quarterly meeting of the Northern California Oracle Users Group (NoCOUG). The NoCOUG meetings provide an excellent opportunity for Oracle DBAs and developers to attend technical sessions to improve their skills. Attendance is free for members and $40 for non-members. Where else can you get a day packed with three technical tracks to choose from AND a free lunch?!

To learn more about NoCOUG, visit http://www.nocoug.org

The “Oracles of Oracle” Recommend Technical Resources

On the last day of Oracle OpenWorld, a panel featuring a who’s-who in the Oracle arena convened to take audience questions. When asked for the best technical books they’ve read in the last year, the Oracles recommended:

  • “Oracle8i Internal Services for Waits, Latches, Locks, and Memory” by Steve Adams
  • “Scaling Oracle8i: Building Highly Scalable OLTP System Architectures” by James Morle
  • “Oracle PL/SQL Tips & Techniques” by Joseph C. Trezzo
  • “Oracle Performance Tuning Tips & Techniques” by Rich Niemiec

Their favorite websites for finding answers to those nagging Oracle questions:

Mini-Presentations Worth a Look

Oracle Education presented lots of mini-lessons at Oracle OpenWorld, and slide shows for 33 of these mini-lessons. (You will need an unzip utility and Microsoft PowerPoint Viewer.) When viewing a presentation, be sure to check the slide notes for additional information. (This option is under the View menu in Microsoft PowerPoint.) Following are some valuable presentations recommended by the folks at Database Specialists:

  • New 8i Oracle Tuning Tools (Rick Pulliam)
  • Administering JAVA in an Oracle Database (Scott Gossett)
  • The Internals of Data Storage (Scott Gossett)
  • Oracle 8i Advanced Replication Features (Ranbir Singh)
  • Materialized Views and Dimensions (Susan Jang)
  • Oracle Enterprise Manager v2.1: Tool of Choice (Bill Sutton)
  • XML and Oracle (Anna Atkinson)

Welcome to Our Newest Client: Wily Technology

Database Specialists is excited to be working with Wily Technology. Wily Technology’s mission is to help e-businesses build and operate world-class web systems using Java. Wily Technology delivers products and services providing high performance and reliability to custom Java applications. Some of Wily Technology’s offerings leverage Oracle technology, and that is where we are offering assistance. For more information about Wily Technology, visit their website at http://www.wilytech.com.

On the Lighter Side

Here is a joke heard at Oracle OpenWorld:

Question: What’s the difference between a terrorist and a DBA?
Answer: You can negotiate with a terrorist!

(You know those DBAs… always wanting data integrity!)

Leave a Reply

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