Hosted by PG&E

November 2, 2006

at PG&E, San Francisco, CA


Rate this conference

See directions to the conference location near the bottom of this page.


8:00 - 9:00 Registration and Continental Breakfast - Refreshments Served
9:00 - 9:30 General Session and Welcome - Darrin Swan, NoCOUG President
9:30 - 10:30 Keynote: Why You Can't See Your Real Performance Problems - Cary Millsap, Hotsos Enterprises
10:30 - 11:00 Break
  Room 308 Room 304 Room 301B
11:00 - 12:00
Session 1
Questioning Method R by Cary Millsap, Hotsos Enterprises RAC Performance Tuning Best Practices by Sri Subramaniam, Oracle Corporation No session
12:00 - 1:00 Lunch
1:00 - 2:00
Session 2
The New Data Pump by Caleb Small, caleb.com Web Application Security with JAZN - Implementing the Superstition in JDeveloper by Peter Koletzke, Quovera and Duncan Mills, Oracle Corporation Developing High-Class UML Class Models by Jeffrey Jacobs, Covad Communications
2:00 - 2:30 Break and Refreshments
Last Chance to visit the vendors.
2:30 - 3:30
Session 3
Planning and Installing a RAC Database by Caleb Small, caleb.com Unraveling the Mysteries of Web Application Communications by Peter Koletzke, Quovera Oracle Workload Characterization by Andy Rivenes, AppsDBA Consulting
3:30 - 4:00 Raffle
4:00 - 5:00
Session 4
Root Cause and Other Urban DBA Legends by Brian Hitchcock, Sun Microsystems SQL Design Patterns by Vadim Tropashko, Oracle Corporation JSP Web Pages with a Database Backend by Joel Thompson, Rhino Systems
5:00 - ??? NoCOUG networking and happy hour, upstairs at Beale Street Bar & Grill, 133 Beale St, San Francisco, CA
(Directions: Leaving the conference, walk left on Beale about one block. We will be upstairs.)

Mark your calendar for NoCOUG's Winter Conference:
February 8, 2007 at Oracle Corporation in Redwood Shores.



Speaker Abstracts for Fall Conference


“Why You Can't See Your Real Performance Problems” - Cary Millsap, Hotsos Enterprises

Reflecting across nearly 20 years of solving Oracle performance problems, I can recognize a single pattern of behavior that is the dominant reason for failure in all the projects I've witnessed. In almost every case I've seen, failures in diagnosing and repairing performance problems have been caused by unrecognized SKEW in diagnostic data. This presentation shows several examples that illustrate why skew is such a pervasive problem for performance analysts.

Room 308
“Questioning Method R” - Cary Millsap, Hotsos Enterprises

In 2003, Cary Millsap and Jeff Holt prescribed a new Oracle performance problem diagnosis method called Method R in the book Optimizing Oracle Performance. The central tenets of Method R are that you should sequence your performance analysis tasks in business priority order, and that the most efficient way to analyze performance is to decompose the total end-user response time for those prioritized business tasks. Two years after its formal introduction, supporters of Method R cite extraordinary successes, and its critics describe various inadequacies. This session presents a refined understanding of Method R that incorporates some years of experience with the method since its invention. The session begins with a description of the method and its distinguishing features. It proceeds with a sequence of responses to commonly recurring questions that prospective Method R adopters have to answer.

“The New Data Pump” - Caleb Small, caleb.com

Datapump is the next generation of Oracle's Import/Export utility. It's architecture is radically different offering many new benefits, as well as some serious gotchas for the uninitiated. This session explores the architecture and use of Datapump and includes numerous live demos of the new tool. Learn about performance and security enhancements, new features, significant differences from and the future of the old Import/Export, and critical methods for launching, monitoring, and stopping Datapump jobs. This session will be of benefit to anyone who is currently using the Import/Export utility, or who will be using Datapump in the future.

“Planning and Installing a RAC Database” - Caleb Small, caleb.com

Real Application Cluster technology is gaining acceptance in the industry. It brings many benefits in terms of scalability, reliability, and high availability. It also represents some significant challenges to successfully install and operate. This session explores the critical success factors required to plan and install a RAC database, including both technology and people & process issues. Learn the requirements of storage and network engineering that must be addressed before even considering RAC, understand how to set realistic expectations from RAC, step through the decision making and installation process including new tools in 10gR2 and best practices. This session will be of benefit to anyone who is currently facing a RAC install, or in the planning stages of one.

“Root Cause and Other Urban DBA Legends” - Brian Hitchcock, Sun Microsystems

Over the last several years, I've worked on a number of cases that involved performance, down servers, upgrades gone bad etc. Taking each major case in chronological order, what worked, what didn't, did we ever get root cause? Was 10046 trace, wait states, STATSPACK useful? Example -- user reports that Oracle was sorting dates incorrectly -- and the user was right? How can this be?

Room 304
“RAC Performance Tuning Best Practices” - Sri Subramaniam, Oracle Corporation

The session will cover the following topics in RAC:

  • Quick RAC architecture review
  • Determine RAC-specific tuning components
  • Tune instance recovery in RAC
  • Determine RAC-specific wait events, global enqueues, and system statistics
  • Implement the most common RAC tuning tips
  • Use the Automatic Workload Repository in RAC
  • Use the Automatic Database Diagnostic Monitor in RAC
  • Key Diagnostics

“Web Application Security with JAZN - Implementing the Superstition in JDeveloper” - Peter Koletzke, Quovera and Duncan Mills, Oracle Corporation

Although ultimate security may well be a "superstition," application security is an important component of system design. You must carefully design which users may access which parts of your application. This is true of all applications, but security plays an even larger role in web applications that are often open to access from a wider user base, sometimes even an Internet audience. The Oracle Application Server's component Oracle Containers for J2EE (OC4J) offers runtime services for Java-based web applications. OC4J provides a security feature, JAZN (Java authorization and authentication provider), which allows developers to use standard Java security libraries to implement user access and restriction features in their applications.

This presentation explains this feature of the OC4J server and discusses how it provides solid security services for J2EE web applications. The presentation explores different ways to store user credentials in JAZN and how to tap into existing Lightweight Directory Access Protocol (LDAP) providers such as Windows' Active Directory. It also describes the JAZN ability to access user credentials stored in XML files and how to switch back and forth between these two styles when moving from development to production credential stores. Then this presentation describes and demonstrates how to set up and code security hooks into your application using JDeveloper 10g so you can restrict and permit user access and operations to your valuable enterprise data.

“Unraveling the Mysteries of Web Application Communications” - Peter Koletzke, Quovera

Web application communications between client browser, application web server, and database server is usually a bit of a mystery to those accustomed to working with client/server and terminal mode applications. Any web application written in the Oracle environment works within web communications constraints and features. Knowing about the mechanisms involved is important for writing global application data; reading browser information; and debugging.

This presentation explains the mechanics of Hypertext Transfer Protocol (HTTP) -- the network protocol used for all web communications. It describes the roundtrip communication path between the client browser and application server; HTTP request and response messages; methods (get and post); the components of a Uniform Resource Locator (URL); and J2EE deployment files such as web.xml, server.xml, enterprise application archive (EAR), and web application archive (WAR) files. It also compares web communications to Forms code runtime.

“SQL Design Patterns” - Vadim Tropashko, Oracle Corporation

Patterns in procedural programming became popular a decade ago, originated with a landmark book by Gamma et al. Each pattern has its name, so that developers could instantly refer to it and leverage it as a standard solution of a known problem. Unlike a majority of procedural programming languages, SQL is a high abstraction level language. Yet the advanced part of its learning curve demands a SQL programmer to develop the ability to recognize and communicate complex patterns. Beyond a certain point, the skill of piling up subqueries doesn't pay off, and one has to study some rudimentary theory, which classifies known SQL solutions into common design patterns.

Room 301B
“Developing High-Class UML Class Models” - Jeffrey Jacobs, Covad Communications

Class models form the heart and soul of UML modeling, just as ER models form the core of Oracle method and information engineering. Poorly developed models result in brittle, low-quality systems. This presentation will present techniques and guidelines for avoiding common mistakes in class models, resulting in high-quality, robust models and systems.

“Oracle Workload Characterization” - Andy Rivenes, AppsDBA Consulting

Workload characterization is the process of identifying classes of workload, measuring those classes and then identifying their impact to the business. This presentation will explore how this can be done in an Oracle database including how to measure the impact workload classes have on database workload. This information will also be used to show how to enable an organization to better schedule its business processes.

“JSP Web Pages with a Database Backend” - Joel Thompson, Rhino Systems

This presentation walks you through how to create a basic Java/JSP Web Page that uses Oracle as a backend database providing data to fill a table. Discussion will focus primarily on Web Page basics like JSP Lifecycle, HTML/JavaScript, JSP Scriplet, JSTL and Database I/O with JDBC. However some fringe topics will be discussed like N-tier Architectures, and frameworks like Struts, JavaServer Faces, EJB.


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 PG&E in San Francisco:

77 Beale Street, San Francisco, CA 94105

Upon arrival, sign in at the NoCOUG table.

From BART:
Exit the Embarcadero station. Walk approximately one half block down Beale street.

From Bay Bridge:
Exit on Harrison, continue onto Fremont. Turn right on Market, then right on Beale.

From Golden Gate Bridge:
Exit on Marina, continue onto Laguna. Turn left on Bay, right on Columbus, right on Montgomery, left on Clay, right on Davis, then left on Beale.


Copyright © 2006 NoCOUG.  All rights reserved.