SPRING CONFERENCE

May 19, 2005

Hosted by Lockheed Martin

at Lockheed Martin, Building 157, Sunnyvale, CA

 



Refer a Friend

Rate this conference




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

All conference attendees, vendors, speakers and NoCOUG staff must RSVP prior to May 12th in order to receive a Drive-In Pass at the Visitors Center. The same forms of identification are required as last year.

US Citizens: State or Federal Government photo ID (i.e. Drivers License, U.S. Passport).

Permanent Residents: Green Card along with State or Federal Government photo ID (i.e. Drivers License).

Foreign Nationals other than Permanent Residents: Due to more stringent security requirements imposed by Lockheed Martin and the Department of Defense, Foreign Nationals other than Permanent Residents are not allowed entry to the Lockheed Martin facility and therefore can not attend the meeting this year.

Also note: Cameras of any kind are prohibited.  This includes, but is not limitted to, camera phones and PDAs with cameras.

 

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 ‘System’ is a Four-Letter Word – Cary Millsap, Hotsos Enterprises Ltd.
10:30 - 11:00 Break
  Auditorium ECR Conference Room X7 Conference Room
11:00 - 12:00
Session 1
Profiling Oracle: How it Works by Cary Millsap, Hotsos Enterprises Ltd. Index Organized Tables - Are They Right For You? by Scott Martin, Terlingua Software XML - What's In It For Me? by Greg Matus, Pincipal Instructor, Maverick Solutions, Inc.
12:00 - 1:00 Lunch
1:00 - 2:00
Session 2
An Oracle 10g Upgrade Case Study: Looking at System Performance Before and After the Upgrade by Roger Schrag, Database Specialists Inc. JDeveloper 10g View Layer Alternatives -JSP and UIX by Peter Koletzke, Quovera Inc. What's New with Oracle's Identity Management Solutions by David Saslav, Principal Product Manager, Oracle's Identity Management, Oracle Corporation.
2:00 - 2:15 Break
2:15 - 3:15
Session 3
SQL Tuning: An Overview of Why and *How* to Tune SQL by Dan Tow, Singing SQL Tuning Batch Performance - A Real-world Case Study by Virag Saksena, Auptyma Oracle Database 10g: Automatic Performance Diagnosis and Troubleshooting by Prabhaker Gongloor (GP), Senior Product Manager, Database Manageability, Oracle Corporation
3:15 - 3:45 Raffle and Refreshments
In the vendor area.
3:45 - 4:45
Session 4
Future of DBMS and DBA by Noel Yuhanna, Forrester Research Oracle Workload Measurement by Andy Rivenes, Lawrence Livermore National Laboratory Introduction to the SEI Capability Maturity Model (CMM) by Jeffrey Jacobs, President, Jeffrey Jacobs and Associates
5:00 - 6:00 NoCOUG networking and happy hour at Faz, 1108 North Mathilda Avenue, Sunnyvale.  (Directions: Take Lockheed Martin Way (formerly 3rd Ave.) to Mathilda and turn right.  Follow Mathilda 0.7 miles.  Faz is on the left, just before the freeway.)

Mark your calendar for NoCOUG's Summer Conference:
August 18 at ChevronTexaco in San Ramon.

 


 

Speaker Abstracts for Spring Conference

 

Keynote
“Why ‘System’ is a Four-Letter Word” - Cary Millsap, Hotsos Enterprises Ltd.

Perhaps the most common origin of failed performance improvement projects is the failure to communicate. At the root of the matter in the Oracle world is the word "system." This presentation explores the reasons for the problem, the consequences of the problem, and how to solve the problem once and for all.

Auditorium
“Profiling Oracle: How it Works” – Cary Millsap, Hotsos Enterprises Ltd.

Conventional Oracle "tuning" methods are outrageously complex, and they don't work. For more than three decades, good software developers have known how to optimize computer-executed tasks using a simple method that works every time. This presentation describes how to use this method in an Oracle environment, and it demonstrates the method's use with an example.

“An Oracle 10g Upgrade Case Study: Looking at System Performance Before and After the Upgrade” - Roger Schrag, Database Specialists Inc.

Our company uses an Oracle database and an application developed in-house to manage information regarding customer databases. In this presentation we will discuss our company's experience moving this system from Oracle 8i to 10g. We won't focus on the migration steps themselves, because you can read about that in the documentation. Instead we'll focus on our real-life experience of how Oracle 10g handled an application that ran very smoothly on Oracle 8i. In particular, we will look at changes in execution plans (for better or for worse), management of resources such as memory and CPU, and what the various advisors in Oracle 10g had to say.

“SQL Tuning: An Overview of Why and *How* to Tune SQL” - Dan Tow, Singing SQL

SQL tuning frequently offers the best opportunities to enhance overall application performance. It is, fortunately, a highly decoupled problem, enabling even a tuner completely unfamiliar with the application to rapidly find safe, easy-to-implement tuning recommendations that can deliver huge performance improvements. This makes the discipline of SQL tuning highly leveraged, with high rewards for the specialist. This presentation will show an overview of the SQL tuning approach described by Dan Tow in his book, titled SQL Tuning, published by O'Reilly.

“Future of DBMS and DBA” - Noel Yuhanna, Forrester Research

Although DBMS technology is very mature, vendors continue to find new ways to innovative, expanding its scope and supporting new types of applications. Besides relational databases, more products are offering integrated support for XML, Web services, and unstructured data types. So what can you expect in the future for DBMSes? Will database management challenges still exist in the future? This presentation looks at key areas where DBMSes will continue to innovate such as automation, on-demand computing, unstructured data, data grids, and in-memory technologies. How will this impact DBA's and how they should prepare themselves to adapt to these new changes.

ECR Conference Room
“Index Organized Tables - Are They Right For You?” - Scott Martin, Terlingua Software

By storing non-key values along with the key values in an index, Oracle can dramatically decrease the work needed to perform certain queries when compared to a standard B-Tree implementation. This talk not only covers how Oracle implements IOTs, but also walks through detailed examples using IOTs, backed by statistics and execution plans. We will also cover the effects on performance of the overflow table and secondary indices created on IOTs. You will leave knowing when and when not to consider using IOTs in your application.

“JDeveloper 10g View Layer Alternatives -JSP and UIX” - Peter Koletzke, Quovera Inc.

The user interface (View) layer for Java-based web applications is often coded as JavaServer Pages (JSP) files, but Oracle offers an alternative, called ADF UIX, that defines the page using XML instead of HTML. UIX provides some benefits to JSP pages but it has many similarities. Development of both of these alternatives is well supported in Oracle JDeveloper 10g. This presentation explains these two view layer technologies and describes how to develop them using Oracle JDeveloper 10g. It reviews the principles of the MVC design pattern and how work in JDeveloper follows that design pattern. The presentation also discusses both JSP and UIX architectures, code libraries, coding styles, benefits and drawbacks, key features, and intended uses. In addition, it provides conclusions about which style is best for specific situations. Additionally, the presentation will demonstrate how to develop an application in both styles using JDeveloper.

“Tuning Batch Performance - A Real-world Case Study” - Virag Saksena, Auptyma

In this presentation we will take an example from the real world of slow programs, and walk through the analysis and implementation processes. We will cover querying Oracle fixed views to get a quick indicator of bottlenecks and tracing program execution to get a more comprehensive perspective. We will look at different types of fixes, assessing their risk, and effectiveness and effort. We will also be measuring the impact of changes. We will use a case study from a real world example to put some meat behind each of these, so attendees will come away with a good understanding of the performance tuning process.

“Oracle Workload Measurement” - Andy Rivenes, Lawrence Livermore National Laboratory

This presentation will explore Oracle workload measurement and how it relates to Oracle system management. Our profession confuses the processes of performance tuning and workload management and this presentation will try to draw out the distinctions between the two. It will also address what "system performance" really means and then will explore how workload measurement can be used and what economic benefits can be achieved. Real world examples will be used to illustrate how workload measurement can be used as inputs to capacity planning and workload optimization. Although not a "tool" presentation, a couple of options will be addressed to allow the audience to implement workload measurement in their environments.

X7 Conference Room
“XML - What's In It For Me?” - Greg Matus, Pincipal Instructor, Maverick Solutions, Inc.

XML has been touted as the "lingua franca" (a medium of communication between peoples of different languages) and has become an important ingredient in enterprise-level web applications. With the latest releases of Oracle and JDeveloper, Oracle has significantly increased its support of XML. This presentation will explain what XML is and what all the fuss is about. Examples will be presented demonstrating a broad range of uses and benefits of XML. Examples of XML will include: supplying data to a web page, storing project metadata, allowing client-side parsing and formatting of a server-side result set. Examples will also illustrate support for XML in JDeveloper, the Oracle database, Java, JSPs/Servlets, and HTML.

“What's New with Oracle's Identity Management Solutions” - David Saslav, Principal Product Manager, Oracle's Identity Management, Oracle Corporation.

Oracle Identity Management includes a collection of components for managing user identities and controlling user access to applications. Oracle Application Server and Oracle Database have a unified framework for identity and access management that is used by applications throughout the Oracle enterprise. This session provides an overview of new features and capabilities in Oracle Identity Management. These include support for heterogeneous application environments, advanced deployment topologies, expanded authentication modes, and multiple security enhancements. Attendees learn how and why to leverage these features in their Oracle deployments.

“Oracle Database 10g: Automatic Performance Diagnosis and Troubleshooting” - Prabhaker Gongloor (GP), Senior Product Manager, Database Manageability, Oracle Corporation

This presentation focuses on automatic performance diagnosis and troubleshooting capabilities in Oracle Database 10g. The presentation will cover the following topics:
a) Overview of the intelligent infrastructure supporting the performance self-diagnosis capabilities;
b) Performance overhead associated with the intelligent infrastructure;
c) How to use the EM interface to effectively diagnose performance problems in a proactive and reactive manner; and
d) Best practices and lessons learned from real-world customer deployments using this technology.

“Introduction to the SEI Capability Maturity Model (CMM)” - Jeffrey Jacobs, President, Jeffrey Jacobs and Associates

This presentation will provide an overview of the Software Engineering Institutes Capability Maturity Model (SEI/CMM). Topics will include discussion of the purpose of the SEI/CMM, the five levels, the importance of metrics, and how the SEI/CMM framework can be used to understand and improve the quality of software development.

 


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 Lockheed Martin in Sunnyvale:

Address:
Building 157 is located at the intersection of Lockheed Martin Way (formerly Third Avenue) and J Street in Sunnyvale.

From Highway 101:
Go on Highway 101 toward Highway 237. Go east on 237 and exit at Mathilda Avenue. Travel north on Mathilda and turn left onto Lockheed Martin Way (formerly Third Avenue). Take Lockheed Martin Way (formerly Third Avenue) towards J Street. Before you reach the Guard Shack, turn left into the Visitor's Center parking lot. AT the far end of the parking lot, there will be a gate with another guard shack. Tell the guard you are here for the NoCOUG meeting and he will check your ID against the RSVP list. If you are not on the list, you will be turned away. If you are on the list, you will be given a parking pass, told where to park, and allowed through the gate. Please see this map. Follow the route indicated on the map, then turn left onto Lockheed Martin Way (formerly Third Avenue). Building 157 is on the left, and the parking lot is on the right.

From Highway 880:
Go on Highway 880 toward Highway 237. Go west on 237 and exit at Mathilda Avenue. Travel north on Mathilda and turn left onto Lockheed Martin Way (formerly Third Avenue). Take Lockheed Martin Way (formerly Third Avenue) towards J Street. Before you reach the Guard Shack, turn left into the Visitor's Center parking lot. AT the far end of the parking lot, there will be a gate with another guard shack. Tell the guard you are here for the NoCOUG meeting and he will check your ID against the RSVP list. If you are not on the list, you will be turned away. If you are on the list, you will be given a parking pass, told where to park, and allowed through the gate. Please see this map. Follow the route indicated on the map, then turn left onto Lockheed Martin Way (formerly Third Avenue). Building 157 is on the left, and the parking lot is on the right.

Map


Copyright © 2005 NoCOUG. All rights reserved.