Fall Conference 2010

Hosted by Oracle

November 11, 2010

at Oracle Corporation, Redwood Shores, CA


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 - Hanan Hit, NoCOUG President
9:30 - 10:30 Keynote: Oracle OpenWorld 2010 Highlights - Sushil Kumar, Vice President, Oracle Corp.
10:30 - 11:00 Break
  Auditorium Room 101 Room 102
11:00 - 12:00
Session 1
Oracle Exadata: The World's Fastest Database Machine
by Ron Weiss, Oracle
Estimating Cardinality and Query Execution Cost: Use of Jonathan Lewis CBO Methodology
by Dave Abercrombie
... and UIX Begat ADF Faces: How Rich is ADF Faces Rich Client
by Peter Koletzke, Quovera
12:00 - 1:00 Lunch
1:00 - 2:00
Session 2
by Chris Lawson
Building Oracle Enterprise Linux Guests on Virtual Box Windows Host
by Ahbaid Gaffoor, Amazon
Developing High Performance Database Applications with In-Memory Database Cache
by Simon Law, Oracle
2:00 - 2:30 Break and Refreshments
Last chance to visit the vendors
2:30 - 3:30
Session 3
Reliable Datagram Sockets and InfiniBand
by Hanan Hit, HIT Consulting Inc.
Building a Virtualized 11gR2 Linux RAC on a Virtual Box Windows Host
by Ahbaid Gaffoor, Amazon
Visualize Your Data on the Web - The Oracle Fusion Way
by Shay Shmeltzer, Oracle
3:30 - 4:00 Raffle
In the vendor area
4:00 - 5:00
Session 4
Avoiding SQL Performance Regressions: New Techniques for Solving an Old Problem
by Prabhaker Gongloor, Oracle
Oracle Data Warehouse Management With Erwin
by Don Soulsby, Sandhill Consultants
End to End Complete Oracle 10g Grid Control Implementation
by Sakthivel Selvarajan, Ross Stores, Inc.
5:00 - ??? NoCOUG Networking and Happy Hour
at Bay 223, located in the Hotel Sofitel
at 223 Twin Dolphin Drive, Redwood City, CA 94065, (650) 508-7126
(Directions: Leaving the conference,
1. Head east on Oracle Pkwy toward Marine Pkwy 0.4 mi
2. Take the 1st right onto Marine Pkwy 0.2 mi
3. Take the 1st left onto Twin Dolphin Dr 0.6 mi
4. Turn left at Shoreline Dr 377 ft )

Mark your calendar for NoCOUG's Winter Conference:
February 24, 2011 at CarrAmerica in Pleasanton.



Speaker Abstracts for Fall Conference


“Oracle OpenWorld 2010 Highlights” - Sushil Kumar, Vice President, Oracle Corp.

This keynote will showcase the latest Oracle updates - straight from Oracle OpenWorld 2010! In this session, you will learn about the newest technology innovations, including the Oracle Exalogic Elastic Cloud, Exadata Database Machine, Oracle Linux with the Unbreakable Enterprise Kernel, Oracle Solaris, Java roadmap, and more. Attendees will also hear how Oracle's next generation of applications, Oracle Fusion Applications, features the best from Oracle E-Business Suite, PeopleSoft, Siebel, and JD Edwards. Oracle Fusion Applications are built using industry standards-based Java middleware, and integrated with business intelligence, not just process automation.

“Oracle Exadata: The World's Fastest Database Machine” - Ron Weiss, Oracle

Oracle Exadata is the only database machine that provides extreme performance for both OLTP and data warehousing applications at the lowest cost, making it the ideal private cloud consolidation platform. And, the recent introduction of Oracle Exadata Database Machine X2-8 extends Oracle's family of Database Machines, offering customers a choice of secure, scalable, fully redundant consolidation platforms. In this session, we'll examine how Oracle Exadata delivers extreme performance for all database applications at the lowest cost.


CAUTION: Do NOT attend this session if you wish to hear a fluffy marketing spiel designed to sell some fancy new system, or if you want to see abstract 3-D charts that cause your eyes to glaze over within 5 seconds. This presentation is a PRACTICAL, down-to-earth explanation of how experts really solve tough performance problems. Based on his experience solving 6,000 performance problems, Chris Lawson will show you how it's done, and divulge his top-10 tuning tactics.

“Reliable Datagram Sockets and InfiniBand” - Hanan Hit, HIT Consulting Inc.

Reliable Datagram Sockets (RDS) over InfiniBand, which initially was supported in 10g Release 2 in order to support the cluster interconnect is becoming a major player in the new grid infrastructure. RDS in expected to have low overhead, low latency, high bandwidth, while being ultra reliable.

This presentation will focus on the advantages of using RDS over InfiniBand in order to build scalable, high-performance RAC clusters. The topics will include general overview, configuration settings, followed by benchmark evaluation of using RDS when the network is 40Gig versus 10Gig as well as different RAC configurations.

“Avoiding SQL Performance Regressions: New Techniques for Solving an Old Problem” - Prabhaker Gongloor, Oracle

This session covers how Oracle Database's SQL Performance Analyzer feature can be used to accomplish end-to-end testing of SQL response time for system changes such as optimizer statistics refresh, database upgrades, and patch sets. It covers various aspects of SQL performance testing and how SQL Performance Analyzer simplifies them--from capturing the workload to conducting trials for a given system change, comparing the performance data and execution plans, and identifying and tuning the SQL regressions. The session also covers advanced topics such as how to use SQL Performance Analyzer when the test system is not similar to the production system and testing in a scoped and resource-controlled manner in the production environment. Finally, we cover how SPA was used successfully by DIRECTV, Bank of America, and NHN for above mentioned system changes.

Room 101
“Estimating Cardinality and Query Execution Cost: Use of Jonathan Lewis CBO Methodology” - Dave Abercrombie

To successfully tune a query, you need to be able to think like Oracle's query optimizer. Sure, it helps to have intuitive, general knowledge, based on experience and informal rules of thumb. But such general knowledge can take you only so far. To really understand the optimizer, you need to be able to reproduce its cost estimates. Jonathan Lewis has published reverse-engineered optimizer algorithms in his book "Cost-Based Oracle Fundamentals" (Apress 2006). In this presentation, Dave Abercrombie will lead you through those algorithms using real-world examples. You will gain a degree of understanding and confidence with the Oracle optimizer that will improve your tuning skills. This presentation builds upon previous presentations on physical data storage and reading execution plans.

“Building Oracle Enterprise Linux Guests on Virtual Box Windows Host” - Ahbaid Gaffoor, Amazon

In this session attendees will be shown how to build Virtualized Oracle Enterprise Linux hosts on Oracle's Virtual Box running on Windows 7. We will cover the use of the GUI to build a Linux host, then cover cloning of that host towards building a virtualized RAC environment. We will also cover creation of shared storage for use in a virtualized RAC environment. We will also cover creation of bridged and host only network interfaces. Attendees will also be shown how to use the command line utilities provided with Virtual Box. When you leave this presentation you will have all the tools needed to build Virtualized environments on Windows, OS X or Linux.

“Building a Virtualized 11gR2 Linux RAC on a Virtual Box Windows Host” - Ahbaid Gaffoor, Amazon

In this session we continue with our virtualized environments and install an 11gR2 RAC in Virtual Box hosts. We will review the steps needed to setup a RAC environment on a commodity desktop or laptop. Attendees will leave this presentation with the tools needed to get their own RAC environments running on their laptop or desktop machines. Tips and tricks to make your Virtual Host desktop / laptop perform better will also be shared.

“Oracle Data Warehouse Management With Erwin” - Don Soulsby, Sandhill Consultants

The purpose of this seminar is to provide the student with the understanding about Data Warehouse Modeling in Erwin and it's extensions into Oracle's Data Warehouse Platform.

Part 1 - Define and differentiate OLTP, DW and Multi-dimensional models
Part 2 - Define Dimensional model characteristics in Erwin
Part 3 - Application of concepts to Oracle Warehouse Builder
Part 4 - Erwin-assisted Oracle Cube Design

Room 102
“... and UIX Begat ADF Faces: How Rich is ADF Faces Rich Client” - Peter Koletzke, Quovera

Back in the early days of light-client, web applications, Oracle created User Interface XML (UIX) -- a user-interface component set used to render HTML items. Oracle used UIX in JDeveloper 9i to build E-Business Suite (EBS) applications up through EBS release 12i. However, with the advent of the Java standard JavaServer Faces (JSF), Oracle transformed UIX components into standard JSF components and called the new component set "ADF Faces." ADF Faces further evolved into ADF Faces Rich Client (ADF Faces RC) in JDeveloper 11g. Oracle is now using ADF Faces RC to develop Oracle Fusion Applications (the next release of EBS). Thus, ADF Faces RC is highly evolved and is now an important part of the next version of Oracle Applications. In addition, you can use it to create custom web applications.

This presentation provides a close look at the components available in ADF Faces RC. It explains how to take advantage of native ADF Faces RC features such as skins, internationalization support, and built-in Asynchronous JavaScript and XML (AJAX, also called Partial Page Rendering). Since an important aspect of web page design is managing screen real estate, this presentation explores how to achieve the perfect layout using the ADF Faces RC layout components. The presentation also explains and demonstrates container component techniques such as modifying the standard tab order. In addition, this presentation introduces the Data Visualization Tools (DVT) components, which provide super-rich, Web 2.0 functions such as interactive graphs, Gantt charts, pivot tables, and hierarchy viewers.

“Developing High Performance Database Applications with In-Memory Database Cache” - Simon Law, Oracle

Oracle In-Memory Database Cache is a database option that provides real-time, updatable caching for the Oracle database. Oracle In-Memory Database Cache improves application transaction response time by caching a performance-critical subset of tables and table fragments from an Oracle database to the application tier. Cache tables are managed like regular SQL relational database tables within the TimesTen In-Memory Database, Applications continue to read/update data with JDBC, Oracle Call Interface, PL/SQL, Pro*C, and Oracle Data Provider for .NET while benefiting from accelerated performance, automatic synchronization, and high availability. This session covers Oracle TimesTen In-Memory Database functionality/performance.

“Visualize Your Data on the Web - The Oracle Fusion Way” - Shay Shmeltzer, Oracle

In this session we'll show you how to build visually-appealing dynamic Web dashboard that present data from your database. See how you can build interactive graphs, geographic maps, pivot tables, gauges and more in a visual and declarative way. Using simple SQL queries and the power of the Oracle ADF Faces data visualization components we'll show you how to create great looking Web interfaces and extract meaning from your data. The session is focused around an interactive development demo.

“End to End Complete Oracle 10g Grid Control Implementation” - Sakthivel Selvarajan, Ross Stores, Inc.

Grid Control offers a single-window solution that allows you to monitor and manage the complete Oracle IT infrastructure from a single console. Grid Control also offers support for monitoring certain non-Oracle products, for example, IBM WebSphere Application Server, Microsoft SQL Server, Juniper Networks NetScreen Firewall, and so on.

With a broad set of end-to-end monitoring, administration, configuration management, provisioning, and security capabilities, Grid Control reduces the cost and complexity of managing such grid computing environments. Robust service-level management functionality within Grid Control dramatically improves service levels through rich transaction and end-user performance monitoring and deep diagnostics for multi-tier Internet applications.

This presentation will cover the aspects of components, architecture & complete steps to implement in your environment quickly and easily. Different agent installation methods will be covered with pros and cons. Procedure to install Diagnostic Kit, configure Target monitoring & Securing Grid Control infrastructure will be explained. You will also learn best practices & performance tuning of grid control infrastructure.


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.  


A = Conference Location - 350 Oracle Parkway
B = Happy Hour Location - 223 Twin Dolphin Drive
Click A or B to get customized directions

View Larger Map

Copyright © 2010 NoCOUG.  All rights reserved.