About NoCOUG
Online Survey
NoCOUG Board
Site Map


NoCOUG's February 20, 2003 Conference

The NoCOUG Winter Conference was held on Thursday, February 20, at the Hotel Sofitel at Redwood Shores. Some of the presentations from the meeting are available for download.

Conference Description:

The Winter Conference had parallel sessions on the topics of database administration, application development, and a special "Oracle by Oracle" track. Here is the agenda, followed by session descriptions:

08:00 -  - Registration opens. Continental Breakfast.
09:00 - 09:30  - General Session.
09:30 - 10:15  - Keynote: "How Oracle's Complexity Breeds Simplicity" Craig Shallahamer, President, OraPub, Inc.
10:15 - 10:30  - Break
10:30 - 11:15  - Oracle Keynote: Dennis Leung Vice President of Development for 9iAS and J2EE Technologies
11:15 - 11:45  - Break
11:45 - 12:45  - Parallel Session #1:
DBA Application Development Oracle by Oracle

"All About Oracle's Touch-Count Data Block Buffer Algorithm" Craig Shallahamer, President, OraPub, Inc.

Level: Advanced

"Java Basics for PL/SQL Programmers" by Peter Koletzke, Technical Director, Quovera

Level: Intermediate

"Oracle Collaboration Suite" by Steven Levine Vice President, Oracle Corporation
12:45 - 01:45  - Lunch
01:45 - 02:25  - Roundtable Discussions
02:30 - 03:30  - Parallel Session #2:
DBA Application Development Oracle by Oracle

"Managing Production Databases - Best Practices" Noel Yuhanna, Senior Industry Analyst, Giga Information Group

Level: All

"Top Tips for Oracle Designer" by Peter Koletzke, Technical Director, Quovera

Level: Intermediate

"Oracle 9iAS Integration Overview", by Milton Wan, Director of Product Management, Oracle Corporation
03:30 - 04:00  - Afternoon Break and Raffle
04:00 - 05:00  - Parallel Session #3:
DBA Application Development Oracle by Oracle
"Navigating the Oracle Backup Maze" by Robert Spurzem, Senior Product Manager, Legato Systems, Inc.

Level: All

Much Ado About Nothing (NULL) by Walter Schenk, Principal Consultant, Solutech

Level: Intermediate

"Choosing an Integration Product: Comparing Replication, Messaging and Oracle 9iAS Integration", by Prashant Nema, Principle Product Manager, Oracle Corporation
05:15-???  - NoCOUG Networking and Happy Hour at the bar in the Hotel Sofitel lobby

If you have suggestions for future conferences or would like to offer feedback on previous conferences, then please send us an email.

"How Oracle's Complexity Breeds Simplicity" I'm going to lead you through a journey. A kind of story. It's the story about how throughout the ages we have tried to understand our surroundings and make use of them. We began by understanding our world with simple shapes, then numbers and equations, and finally through recognizing the patterns all around us. These patterns can be better understood through the sciences and mathematics of complexity and self-organizing systems. We have learned that simple components operating under simple rules can exhibit very complex behavior. Oracle has throughout the years incorporated aspects of complexity and self-organizing behavior into its core database server. This is allowing Oracle based systems to solve incredibly massive and complex problems that where literally impossible just a few years ago

"All About Oracle's Touch-Count Data Block Buffer Algorithm" Oracle introduced a touch-count based data buffer management algorithm to address the growing size, performance requirements, and complexities of current day systems. Data block buffers are no longer managed using a modified least recently used (LRU) algorithm. The touch-based algorithm introduced in Oracle 8i significantly reduces latch contention, forces buffers to earn their way higher up the main list, and allows for increased granular buffer performance optimization opportunities. This paper details Oracle's touch-count algorithm, how to monitor its performance, and how to manage for optimal performance.

"Managing Production Databases - Best Practices" With the increased number of databases and their ever-growing size, manageability has become a challenge for most customers. In this presentation we look at some of the "best practices in the industry" to manage production databases. We also look at where DBAs put more effort and how they can become more efficient. We then proceed on ways to monitor databases including writing your own custom scripts. We also review some of the 3rd party vendors offering monitoring products and also validate if the remote DBA solutions should be considered. Finally we wrap up with some of the guidelines on improving database availability.

"Navigating the Oracle Backup Maze" Backing up an Oracle database has always been a challenge even for an experienced DBA and now with the introduction of new Oracle9i RMAN features, new backup to disk, snapshots and the like, it is getting even more confusing. This presentation will present and discuss ten common issue surrounding Oracle backup and present some clear recommendations on how to best tailor Oracle backup to your environment.

Much Ado About Nothing (NULL) Unlike a great deal of programming languages relational databases work with the concept of null values. This presentation first provides an overview of the concept of NULL and discusses the functions and operators available in ORACLE to work with NULL values. It then shows how various programming languages interface with NULL values and finally good code practices as they relate to NULL are presented.

Directions to the Hotel Sofitel at Redwood Shores

Address: 223 Twin Dolphins Drive, Redwood Shores, California. Phone: (650)

Southbound- Take Highway 101 South (toward San Jose) to the Ralston
Ave./Marine World Parkway exit. Take Marine World Parkway east which will
loop you back over the freeway. Make a right at the second light onto Twin
Dolphins Drive. The hotel will be on the left.

Northbound- Take Highway 101 North (toward San Francisco) to the Holly
Street exit toward San Carlos. Merge onto Redwood Shores Parkway and make a
left at the second light onto Twin Dolphins Drive. The hotel will be on the


Copyright 2003 NoCOUG. All rights reserved.