Sponsored by Chevron Texaco

was held on August 19, 2004 at

Chevron Texaco San Ramon, CA


Refer a Friend


8:00 - 9:00 Registration and Continental Breakfast - Refreshments Served
9:00 - 9:30 General Session and Welcome - Roger Schrag, NoCOUG President
9:30 - 10:30 Keynote: Understanding by Design: Why Understanding is Different from Knowing – Tom Kyte
10:30 - 11:00 Break
  Room 1240 Room 1220 Room 1130
11:00 - 12:00
Session 1
Strategies for Gathering Statistics by Jonathan Lewis, JL Consulting Get a Handle on DDL Changes Using Oracle Streams by James Koopmann, Director of Technical Consulting, Confio Software Managing Compliance in an Era of Data Growth by Mohan Dutt, Director – Oracle Delivery, Solix Technologies
12:00 - 12:45 Lunch
12:45 - 1:15 Roundtable Discussion in Rooms 1220 and 1240
1:15 - 1:30 Break
1:30 - 2:30
Session 2
The Evolution of Optimization 8i to 10g by Jonathan Lewis, JL Consulting Systems Integration Secrets Using Logical Databases by Eric Buskirk, President, Verican System Deploying Oracle Databases on Networked Attached Storage by Akira Hangai, Principal Technical Staff, Oracle Partner Engineering, EMC
2:30 - 2:45 Break
2:45 - 3:45
Session 3
Inside Multiversioning by Tom Kyte, Vice President, Core Technologies for Oracle GEH, Oracle Corporation Introduction to ADF in JDeveloper 10g — Is it Oracle Forms Developer Yet? by Peter Koletzke, Technical Director and Principal Instructor, Quovera Leveraging Master-to-Master Replication for Efficient Workload Balancing & Data Distribution by Mark Ketchie, Data Mirror
3:45 - 4:15 Break & Raffle
4:15 - 5:15
Session 4
Scaling to Infinity – Partitioning Data Warehouses in Oracle by Tim Gorman, Principal, SageLogix The Disaster Diary: Real Failures and Real Recoveries by Jeremiah Wilton, Independent Consultant Integrating OpenSource and Oracle 10g Spatial with 9iAS Technology by Tony Lopez, eSpatial
5:15 - ? NoCOUG networking and happy hour at O'Kane's Irish Pub, 200 Montgomery St., San Ramon. (Leaving the conference, turn right on Bollinger Canyon Road, right on Market Place, and left on Montgomery Street.)

Our next quarterly conference is November 4, 2004
at the Computer History Museum in Mountain View!!!



Speaker Abstracts for Summer Conference


“Understanding by Design: Why Understanding is Different from Knowing” - Tom Kyte

Many developers and DBAs (not all, but many) approach the database with little or no understanding of how it actually works. Developers approach Oracle assuming it must work just like SQL Server or even worse with the frame of mind that says, "It doesn't matter how it works, I'm using a layer of abstraction to protect me." DBAs approach the server sometimes with a cursory knowledge of how things work, leading them to do things like, "We can skip backing up undo data-it isn't our stuff, we don't need it" or erasing archives because they ran out of space.
This presentation will present some of these foibles and explain how not understanding how the database actually works will lead to disaster. Actual cases (with names removed of course) will be used as examples. Additionally, some examples of things you just might not know about yourself will be explored. Oracle is big and it is a moving target. Understanding it is an ongoing process that we need to continually do.

Room 1240
“Strategies for Gathering Statistics” - Jonathan Lewis

Statistics are important to the Cost Based Optimizer, but how often should you regenerate them, how big should your sample size be, do you need histograms, and what can you do when the statistics collected never seem to be good enough.
In this presentation, we use a simple worked example to show how too many people spend too much (machine) time gathering excessive statistics when they don't really need to.

“The Evolution of Optimization 8i to 10g” - Jonathan Lewis

With each release of Oracle, we see more and more options for producing faster code. Some improvements come from clever new tricks built into the optimiser (such as unnesting). Some improvements come from new features that give us better ways of solving existing problems (such as analytic functions). Some improvements come from new tuning aids that Oracle Corporation supplies (such as stored outline management).
This presentation looks at SQL optimisation from all directions - including a couple of the new features that exist in Oracle 10 to aid in the task of solving performance problems.

“Inside Multiversioning” - Tom Kyte

Back to the basics of read consistency and—more importantly—write consistency. This presentation looks at how SQL statements really are processed, especially those pesky modification statements. Find out why an update that normally takes 10 minutes never finished the other night. You will be amazed at what goes on inside Oracle to deliver a read and write consistent answer.

“Scaling to Infinity – Partitioning Data Warehouses in Oracle” - Tim Gorman

Partitioning is crucial to data warehouses, but how do you decide how to physically decide how to partition. How do you use the different types of partitioning to optimize both end-user performances through partition-pruning, as well optimizing extraction/transformation/loading (ETL)? How is range partitioning best utilized? Hash and list partitioning and sub partitioning? How are data warehouses indexed and how does one sort through the myriad choices of index partitioning? This presentation is the result of lots of practical experience in physical database design for data warehouses, driven by the combination of business requirements and systems requirements. It will provide straight answers and solid guidelines to best utilize this important feature to ensure decision-support success.

Room 1220
“Get a Handle on DDL Changes Using Oracle Streams” - James Koopmann

It is inevitable that someone, somewhere, at some time will make a change to an object or structure within a database. Typically you will never know who or how it was altered until someone or some application starts to complain or show performance problems. The days of searching archive logs and the tedious tasks of comparing before and after images have long gone. A new era of change detection has given way in the form of Oracle Streams. This presentation will introduce you to why change detection is important from a DBA perspective and how the use of Oracle Streams will allow you to gain control of your database.

“Systems Integration Secrets Using Logical Databases ” - Eric Buskirk

Coordinating the schedules of multiple projects can be incredibly difficult for DBAs and data architects. The complexity of which increases exponentially with each additional application. This presentation encompasses the utilization of a logical database layer comprising views, triggers and stored procedures to support dynamic database and development environments.

“Introduction to ADF in JDeveloper 10g — Is it Oracle Forms Developer Yet?” - Peter Koletzke

As use of the Java language matures and more technologies are based upon Java, designing, developing, and deploying Java-based applications becomes more and more complex. Oracle has long offered tools that assist with designing, developing, and deploying applications; its current focus for application development is the Java tool JDeveloper. In its 10g release, JDeveloper offers a new set of features, libraries, and methods, called the Application Development Framework (ADF) that promises to simplify Java development tasks. In addition to standard editors and wizards, ADF in JDeveloper simplifies the formerly daunting task of connecting front-end Java code to database elements —something Oracle Forms developers have long taken for granted. This presentation describes ADF and how it can assist with development of a Java-based application. It explains how ADF fits into the concept of a Java framework as well as how it follows the J2EE MVC design pattern. The presentation discusses how the additional development productivity promised by frameworks and specifically by ADF comes with additional challenges. It also shows the various tools in JDeveloper that support the “ADF development method” and how they ease the task of connecting Java front-end code to the database. Finally, the presentation offers insight about what type of development shop will benefit the most from ADF and whether you can achieve the productivity of an Oracle Forms environment by using this release of ADF.

“The Disaster Diary: Real Failures and Real Recoveries” - Jeremiah Wilton

The Disaster Diary series examines the technical details of major real-life database failures at prominent Oracle customer sites. Attendees will learn what led to failures, how technical staff resolved them, and what a DBA could have done to prevent or shorten them. This series breaks down the time spent performing various tasks to resolve problems, and shows how DBAs can think critically during a failure to drastically reduce time to recovery. Oracle's much-ballyhooed features for high-availability, such as DataGuard and RAC can be complex and prohibitively expensive. This series shows that in most cases, the expensive technologies provide less advantage than might have been expected. Whenever possible, attendees will see demonstrations of the failure and recovery scenarios on live, running Oracle instances.

Room 1130
“Managing Compliance in an Era of Data Growth” - Mohan Dutt

Data growth fueled by compliance with stricter data retention regulations (such as Sarbanes - Oxley, HIPAA, etc.) is a pivotal challenge for enterprises today. Learn how to implement a best practice in Data lifecycle management (DLM) to manage compliance with these regulations while maintaining optimum performance. A best practice in data management allows customers to: - define and enforce data retention compliance - archive inactive data to an online archive that preserves transparent user access. This presentation will present a roadmap to identifying the impact of data retention compliance on your business performance, and how a best practice in data lifecycle management can help to comply with these important new regulations while maintaining performance.

“Deploying Oracle Databases on Networked Attached Storage” - Akira Hangai

This presentation will introduce Networked Attached Storage as production storage platform for Oracle database implementations. With NAS, clients on a network can share information on a storage device via a file server. We will cover best practices to deploy an Oracle Database on NAS storage. NAS storage allows IT organizations to utilize existing network infrastructure and expertise to comfortably run multiple instances of an Oracle Application on the same device. Highlights include: 1) The enhanced performance and scalability of an Oracle Database running on NAS2) Understand benefits of implementing NAS in Oracle database environment.

“Leveraging Master-to-Master Replication for Efficient Workload Balancing & Data Distribution” - Mark Ketchie

This session will discuss how to reduce system outage time and costs by easily and cost-effectively distributing large Oracle data volumes and workloads across a number of masters and distributed database applications. The audience will learn:

  • Why master-to-master topology wins over other replication methods?
  • How to rapidly put master-to-master replication into practice?
  • How to overcome the challenges of migrating to a master-to-master solution?
  • The criteria for selecting a master-to-master replication solution.
“Integrating OpenSource and Oracle 10g Spatial with 9iAS Technology” - Tony Lopez

This presentation includes a hands-on approach to creating a Secure. Available and Scaleable Geospatial application utilizing the power of Oracle 10g and 9iAS as well as various OpenSource technologies including Eclipse, Jasper and Java Server Faces. Recent trends to mix Open Source, Oracle and other technologies are taking shape more and more. The desire to create a flexible and powerful mix of these technologies is taking aim at the core of the Geographical Information Systems (GIS) communities. Long standing proprietary formats are giving way to a more open and standards approach to delivering light-weight, but powerful Geospatial solutions to the Internet.


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

Directions to ChevronTexaco Park in San Ramon

Address: 6101 Bollinger Canyon Road San Ramon, CA 94583
Please note that the conference building is just after the ChevronTexaco Campus.
Upon arrival, enter the building at the East entrance where you'll find NoCOUG representatives ready to sign you in.

From Highway 680 South:
Exit at Bollinger Canyon Road. Turn left onto Bollinger Canyon Road (heading east over the freeway). After passing ChevronTexaco Park Circle West, turn right into Bishop Ranch 1. Address 6101 is the first building after entering the parking lot. Park anywhere not restricted.

From Highway 680 North:
Exit at Bollinger Canyon Road. Turn right onto Bollinger Canyon Road (heading east). After passing ChevronTexaco Park Circle West, turn right into Bishop Ranch 1. Address 6101 is the first building after entering the parking lot. Park anywhere not restricted.


Copyright © 2004 NoCOUG. All rights reserved.