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.

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 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 (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.

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.

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.

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.

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.

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.

Topics:
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

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.

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.

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.

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.