Spring Conference 2010

Hosted by Oracle

May 20, 2010

at Oracle Corporation, Redwood Shores, CA

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

For years IT management has been treated as a silo. Systems management vendors have offered highly specialized solutions for managing discrete IT components. This approach is no longer satisfactory for the modern IT organizations which seek to deliver higher business value. Join Richard Sarwal SVP of Product Development for a detailed look at the new Oracle Enterprise Manager 11g product with its breakthrough technologies that empower IT to drive business efficiency and agility. This this keynote session, Sushil will discuss topics including:

• What can an integrated, management-aware application stack do for your automated business processes.
• The game changing nature of IT-Business integration.
• How you can pre-empt unforeseen IT problems through a new community approach to systems management.

If you are planning to upgrade to Oracle Database 11g from Oracle9i Database or Oracle Database 10g, this session is a rare opportunity to learn firsthand from an Oracle expert. In this session, we'll cover all the basics you need to know about upgrading to Oracle Database 11g, including all the required preparatory steps, which upgrade strategies best fit your environment, how to address post-upgrade performance analysis, along with helpful tips and common pitfalls to watch out for.

As the amount of information within organizations continues to grow, so does the challenge of protecting that information. Organizations today are struggling with how to protect against data breaches, and ensure regulatory compliance. By utilizing you're the security capabilities in the Oracle database, organizations can cost-effectively secure all the mission-critical information they rely on. In this session, you will learn about Oracle's comprehensive database security solutions including transparent data encryption, data masking, privileged user access control, automated compliance reporting, and more.

As data warehouses triple in size every two years with ever increasing demands from business users to get answers faster, existing Data Warehousing systems struggle to keep up. A new approach that optimizes software and hardware for your data warehouse is required. In this session, we'll examine the latest intelligent optimizations in Oracle Database 11g Release 2 and Oracle Exadata Version 2 that deliver extreme performance and scalability, improving query execution times by at least a factor of 10x, and provide the ideal consolidation platform.

• On September 15, 2009 Oracle announced the world's first database appliance designed to run both OLTP and data warehousing workloads. Oracle's Database Machine V2 is based on Sun hardware utilizing commodity components and x86 processors.
• In this presentation we will review architecture and functionality of Database Machine enabling high performance and scalability and will discuss challenges of strategic capacity planning, tactical performance management and operational workload management for this environment.

This presentation starts with a brief overview of connection management in Oracle RAC and then focuses on workload management, including exploiting cluster services, connection load balancing, and run-time workload balancing. Finally, it shows how to create your own run-time workload management, using the standard load balancing advisory framework. The presentation goes through demonstrations using a live Oracle RAC cluster, illustrating the internals of workload management and how to monitor it. The live demos simplify understanding of this rather complex topic.

This presentation starts with a brief overview of connection management in Oracle RAC and then focuses on workload management, including exploiting cluster services, connection load balancing, and run-time workload balancing. Finally, it shows how to create your own run-time workload management, using the standard load balancing advisory framework. The presentation goes through demonstrations using a live Oracle RAC cluster, illustrating the internals of workload management and how to monitor it. The live demos simplify understanding of this rather complex topic.

Oracle 11g adds support for a powerful new type of partitioning named "Reference Partitioning." Unlike other partitioning methods which partition tables individually, Reference Partitioning supports complex, nested hierarchies of tables, all partitioned together under a single root table. Under appropriate circumstances, this partitioning method can significantly simplify the management and aging out of large sets of complex data.

This presentation will examine advantages, disadvantages and a wide range of other considerations related to the use of Reference Partitioning. It will also illustrate how Oracle's 10046 Extended SQL Trace Data and controlled experiments can be used to analyze and better understand the behavior of this new feature.

Before you can tune an SQL statement, you need to obtain, and interpret, an execution plan. These steps are not trivial. Misunderstandings and confusion are common. In this presentation, you will learn how to correctly obtain and interpret an SQL execution plan. You will learn the many wonders of Oracle's DBMS_XPLAN, and you will be introduced to the essential technique called "Cardinality Feedback" that was pioneered by Wolfgang Breitling. Most importantly, you will learn how to avoid common mistakes in reading execution plans. With these skills, you will be able to eliminate guess work, and increase your SQL tuning efficiency, accuracy, and confidence.

JavaServer Faces (JSF) is a Java-based user interface technology used primarily to develop web applications. It is currently the most popular UI technology in the Java world and it is a key technology in the Oracle Application Development Framework (ADF). Oracle's Fusion Applications (formerly E-Business Suite) use JSF as the main user interface technology.

This presentation provides an in-depth overview of JSF technology as it is used with ADF to build applications in JDeveloper. It discusses the basic communication paths used when running a JSF application. The presentation also explores development details for creating and testing JSF files. It describes the contents of runtime files such as backing beans and managed beans, message bundles, faces-config.xml, and web.xml. The presentation also briefly explores how to link data from the database into the JSF page so it can be saved or retrieved from the database. Throughout this presentation, sample code and demonstrations show how these concepts manifest in a sample application.

Oracle SQL Developer supports the development of SQL and PL/SQL code. You can create, edit, compile, and run your code using the editors provided. Creating and compiling code is only one aspect of developing code. Code that has been successfully compiled is not necessarily good or even accurate code, so debugging, tuning, and testing are as important as the initial phase of writing. Prior to SQL Developer 2.1, the rich debugging capabilities allowed you to step into your code to debug and trap errors; a process you need to repeat for each case or whenever you update the code. SQL Developer 2.1 introduces Unit Testing, a powerful feature that provides a framework or test harness for you to develop a suite of tests that can be run and rerun. Testing code using a framework means that you can create a wide variety of tests and rerun them whenever needed, for example, when you change or update the code. It means you can test for regressions and unusual or edge cases. In this session, we show you how to use SQL Developer Unit Testing and how to create and run unit tests.

New in Oracle Database 11gR2, the "recursive common table expression" (CTE) gives us yet another tool to manage hierarchical data. A recursive CTE is composed of one or more "anchor members" followed by one or more "recursive members." For example, to find all the ancestors of George Walker Bush, we create anchor members that list his parents followed by recursive members that identify his male ancestors and female ancestors. Recursive common table expressions can also be used to generate rows; for example, we can easily list the members of the Fibonacci sequence.

In this session, we study recursive common table expressions and compare them with queries written using the traditional "CONNECT BY" proprietary Oracle syntax.

This session illustrates some of the various methods available for integrating SOA with the Application Development Framework. The session will provide multiple live demos showing how this integration can take place as well as detailing how to customize some of these tie-ins.