Hosted by Oracle Corporation

February 8, 2007

at Oracle Corporation, Redwood Shores, 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 - Lisa Loper, NoCOUG President
9:30 - 10:30 Keynote: The Future of Database and Information Technology - Juan Loaiza, Oracle Corporation
10:30 - 11:00 Break
  Auditorium Room 102 Room 103
11:00 - 12:00
Session 1
Oracle Performance Management - Real-world Case Studies by Gaja Krishna Vaidyanatha, DBPerfMan Thinking Out of the Box: Redefining Database Storage Management with ASM by Ara Shakian, Oracle Corporation Oracle 11g Secure Files: Unifying files in the database by Amit Ganesh, Oracle Corporation
12:00 - 1:00 Lunch
1:00 - 2:00
Session 2
Oracle's ASM Reduces Cost of Deploying VLDB by Hanan Hit and Lina Shabelsky, SkyRider RMAN in the Trenches: To Go Forward, We Must Backup by Philip Rice, UC Santa Cruz The Tie That Binds: An Introduction to ADF Bindings by Peter Koletzke, Quovera
2:00 - 2:30 Break and Refreshments
Last chance to visit the vendors.
2:30 - 3:30
Session 3
Comparing SQL Trace and ASH by Graham Wood, Oracle Corporation Fixing Broken SQL by Dan Tow, Singing SQL Oracle Database 11g: Preserve Order Amid Change with Database Replay and SQL Replay by Mughees Minhas and Leng Tan, Oracle Corporation
3:30 - 4:00 Raffle
4:00 - 5:00
Session 4
Real World Performance Panel and Q&A Session by Andrew Holdsworth, Juan Loaiza, and other panelists, Oracle Corporation Oracle SOA Suite - How to Integrate Databases and Applications into SOA by David Lundvall, Oracle Corp. No Session
5:00 - ??? NoCOUG Networking and Happy Hour: Late breaking news! Oracle Technology Network (OTN) will be hosting a Linux Installfest at the conference. FREE Oracle & Enterprise Linux developer software - everything you need to build a complete development stack. Come and pick up the software, ask your questions, and either watch the demos or bring your laptop and get help installing Oracle 10g (XE and EE versions). Requirements: 512MB RAM minimum. Pizza and beverages will be provided!

Mark your calendar for NoCOUG's Spring Conference:
May 17, 2007 at Lockheed Martin in Sunnyvale.



Speaker Abstracts for Spring Conference


“The Future of Database and Information Technology” - Juan Loaiza, Oracle Corporation

The current state and the future of databases and IT is a topic of much debate. According to some, IT has reached a state of maturity and it is no longer a competitive differentiator. On the other hand, consumers of IT services often complain about IT being slow, unreliable and expensive. This presentation analyzes the current state of Information Technology and highlights the new revolutionary transformations underway that will enable a more efficient, reliable and agile IT environment.

“Oracle Performance Management - Real-world Case Studies” - Gaja Krishna Vaidyanatha, DBPerfMan

This presentation shares with you the core principles of performance management utilized to determine, investigate, and implement solutions to real Oracle tuning issues. Every case study discussed is a real-world performance problem that was solved using a repeatable and reliable method. Bottom line - Oracle performance is a mathematical science that behooves us to back everything with mathematical evidence....not expert opinions!!!

“Oracle's ASM Reduces Cost of Deploying VLDB” - Hanan Hit and Lina Shabelsky, SkyRider

Oracle's ASM (Automatic Storage Management), part of the Oracle 10g release, accesses the I/O subsystem through the kernel without the overhead of the host operating system. With ASM, Oracle 10g changes the rules of the game of cost vs. scalability and availability for building large database systems. In this presentation we describe how we built a terabyte decision support system using low-cost NetApp storage hardware. We cover the benefits of managing a large database with hundreds of data files using ASM. We also demonstrate how implementation of external redundancy of the storage level helps simplify ASM solution and minimize hardware cost. We analyze our choice of architecture, including the use of Oracle's Snap-Manager (SMO) for simplifying backup and recovery. We explain our choices of design patterns for IP-SAN and ASM including the use of storage protocols. We discuss monitoring capabilities and present performance figures to prove the benefits. We conclude with a brief discussion of future benefits of using InfiniBand in such architectures.

“Comparing SQL Trace and ASH” - Graham Wood, Oracle Corporation

SQL trace or Event 10046 have been available since Oracle V7 and is widely used to help diagnose application performance issues. It provides detailed logging of where a session is spending time. However SQL tracing is expensive and can only be used on an 'as required' basis.

Active Session History (ASH) was introduced in Oracle 10g and captures session that are working in the database on a periodical basis. This statistical data can be used to satisfy many of the requirements for which people have traditionally used SQL trace, but with the big advantage that it is always on for all sessions.

“Real World Performance Panel and Q&A Session” - Andrew Holdsworth, Juan Loaiza, and other panelists, Oracle Corporation

Andrew Holdsworth will moderate a panel of Oracle technology leaders including Juan Loaiza and Graham Wood. The panel will discuss real world performance topics and will field questions from the audience.

Room 102
“Thinking Out of the Box: Redefining Database Storage Management with ASM” - Ara Shakian, Oracle Corporation

Today's enterprises require integrated and automated management tools to manage the growing complexities in their data centers. The Automatic Storage Management (ASM) feature in Oracle Database 10g redefines the traditional methods for database volume and file management, streamlining administrator roles and responsibilities and further empowering the DBA while at the same time simplifying storage administrator tasks. This presentation discusses the new database storage management paradigm, flexible management best practices utilizing Enterprise Manager Grid Control, ASMCMD and SQL as well as storage capacity and performance monitoring, alerts and matrices. Other relevant topics such as delegating management responsibilities to the appropriate personnel (DBA and systems administrator), interoperability with third party LVMs, and file systems are also discussed.

“RMAN in the Trenches: To Go Forward, We Must Backup” - Philip Rice, UC Santa Cruz

Backups are not glamorous, but essential. RMAN has many good features, but that also means there are subtle points with plenty to learn. This presentation is not a 30,000 foot overview of features. It is a sharing of personal experiences, with lessons learned. We'll look at implications of infrastructure and feature choices. And we'll have a sampling of The Good, The Bad, The Ugly.

“Fixing Broken SQL” - Dan Tow, Singing SQL

Most developers spend most of their time maintaining code they did not originate. Frequently, developers must fix SQL without knowing its business purpose; this is especially true of performance specialists, who often work on SQL for applications, or parts of applications, that are unfamiliar. Surprisingly, there are patterns in most incorrect SQL that you can learn to recognize and repair even without knowing the purpose of the SQL. This presentation reviews a breakdown of the most common recognizable patterns in broken SQL, and teaches how to find and fix what's broken with minimal information apart from the bare SQL. The resulting repairs frequently enable better performance, usually fix corner-case functional defects, and invariably make the SQL clearer and easier to maintain. For tuning specialists, an understanding of these patterns enables an unexpected bonus service while tuning someone else's SQL, you also find and fix a subtle functional problem they did not even know existed.

“Oracle SOA Suite - How to Integrate Databases and Applications into SOA” - David Lundvall, Oracle Corp.

This session is focused on Service Oriented Architecture (SOA) and will overview the various components of Oracle's SOA Suite, including BPEL Process Manager, Web Services Manager, Business Rules Engine, and Business Activity Monitoring. Use of these components and their benefits will be discussed, along with a demo.

Room 103
“Oracle 11g Secure Files: Unifying files in the database” - Amit Ganesh, Oracle Corporation

Oracle 11g Secure Files is a next generation file technology built in the database. Most Oracle customers have increasing amounts of non-relational data that ranges from entities like check images to corporate documents. Secure Files provide performance comparable to traditional file technology and at the same time built in the database. Secure Files are backward compatible to LOB programmatic APIs. That allows existing applications to leverage most of the new technology without changing the applications themselves. Secure Files implement cutting edge file technologies that are not yet all available with most file systems - including transparent encryption, smart compression, and de-duplication. That coupled with the advantages of being part of the database, creates for the first time a unified platform for storing files with high performance and high availability while utilizing database technology like Text Indexing, ASM and Audit Vault. Unifying the storage of files and relational data in the database further allows you to easily and securely manage files alongside the relational data.

“The Tie That Binds: An Introduction to ADF Bindings” - Peter Koletzke, Quovera

Normally, connecting database data to the user interface of a web application requires some work. Oracle Application Development Framework (ADF) provides a feature called ADF Bindings that you can use to accomplish this task. ADF Bindings is part of the ADF Model layer, which is recognized as the most innovative and remarkable technology in the ADF stack. This presentation briefly reviews where ADF Model (ADFm) fits and how one of its components, ADF Bindings, allows you to quickly connect components from any user interface library such as ADF Faces and JSF Reference Implementation to business services such as ADF Business Components. The presentation provides details and shows examples of how ADF bindings work; how to automatically bind data elements to visual elements; what types of bindings are available; and where binding code appears. It also explains the basics of the expression language used to bind Model layer components to View layer components.

“Oracle Database 11g: Preserve Order Amid Change with Database Replay and SQL Replay” - Mughees Minhas and Leng Tan, Oracle Corporation

Before system changes are made, such as database upgrades or configurations changes, extensive testing is usually performed to validate the changes. However, despite the testing, unforeseen results are often seen when the change is applied in the production environment such as performance degradation, unexpected errors, etc. Oracle Database 11g introduces two new features, Database Replay and SQL Replay, that are designed to help manage and cope with such changes by significantly reducing the time, cost and risk associated with them. These features allow a DBA to assess the impact of a change on system performance, they help detect unexpected errors and offer advice on how to remedy the problems identified. In this presentation we will describe the two features, explain how they work and the kind of problems each feature is designed to address, followed by a live demonstration of the product.


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 the Oracle Conference Center

350 Oracle Parkway, Redwood Shores, California.  Phone: 650-633-8300 Fax: 650-633-8399

Take Highway 101 South (toward San Jose) to the Ralston Ave./Marine World Parkway exit.  Take Marine World Parkway east which will be left at the light.  Make a left onto Oracle Parkway.  350 Oracle Parkway will be on the right.

Take Highway 101 North (toward San Francisco) to the Ralston Ave./Marine World Parkway exit.  Take the first exit ramp onto Marine World Parkway.  Make a left at the first light onto Oracle Parkway.  350 Oracle Parkway will be on the right.  


Copyright © 2007 NoCOUG.  All rights reserved.