Deep Dive Sessions
Wednesday, February 5, 2013, Deep Dive Sessions
These sessions are free with the purchase of a full conference pass. Choose a track below to see the sessions that are offered.
|Application Development||Business Intelligence||DBA Deep Dive|
That’s Not Where I Want That!
Jorge Rimblas, Enkitec
Room 505 1:00 – 3:00 PM
You’re creating Application Express (APEX) applications already, but you wish your screens would look better. Moving regions around, changing their size, width, placing items and buttons—it’s all frustrating and painful. In this session, you’ll learn how to position your elements and better implement the vision you have for your applications. We’ll go into details of the attributes provided by APEX to make this happen as well as learn some HTML and CSS that will allow you to personalize your applications. You’ll be more comfortable with CSS and how it really works.
ADF On-Ramp: What You Need to Know to Use ADF
Peter Koletzke, Quovera
Room 504 3:15 – 5:15 PM
This presentation explains and shows what kinds of development methods you will use when working with Application Development Framework (ADF) in JDeveloper. It provides guidelines for how much you need to know about the various languages used and the core ADF technologies: ADF Business Components, ADF Faces, and JavaServer Faces. It also describes and shows the files you will use to build an application and to test the application. In addition, the presentation offers advice on how to learn what you need to know before starting Java web development in JDeveloper.
Learn from Fellow Developers – Best Practices When Developing an ADF Mobile App
Joe Huang, Oracle Corporation
Room 506 3:15 – 5:15 PM
Learn from your fellow ADF Mobile developers! Since ADF Mobile was released in 2012, many Oracle internal and external developers have used ADF Mobile to create a variety of enterprise applications, meeting requirements around SCM, CRM, HCM, and many other enterprise processes. Along the way, we discovered many best practices and lessons learned around performance tuning, leverage device services, and constructing user-friendly mobile interfaces. Furthermore, developers used a variety of techniques and protocols to extend enterprise data and applications to ADF Mobile-based applications. In this session, we will discuss the various best practices we have learned around developing an ADF Mobile application, as well as discussing different mechanisms and examples of extending an enterprise application to mobile devices using ADF Mobile.
Hands-on Introduction to Oracle Application Express
Jennifer Kreie, New Mexico State University
Room 505 3:15 – 5:15 PM
This workshop is a hands-on introduction to Application Express (APEX) for people who have little or no experience using APEX. Handouts, online SQL scripts, and twenty videos provide exercises that introduce several APEX tools and features. Workshop attendees will: 1. Create an APEX workspace in the XE interface. 2. Use APEX Administration to create a developer account for that workspace. 3. Use APEX SQL Workshop to run scripts that create and populate tables. 4. Use APEX Application Builder to generate an application with a simple data entry form, a master-detail form, reports (classic and interactive), and a LOV (list of values/combo box) to use in data entry forms. Prior to the workshop, attendees should install Oracle XE on their computer or have developer access to an APEX workspace via the Internet (such as apex.oracle.com). Online scripts for the tutorial are at: http://web.nmsu.edu/~jkreie/oracle/DatabaseTopics.html and videos are at (1st in series): http://www.youtube.com/watch?v=JgWQJUsyLVU.
Dimension Modeling Design Patterns: Beyond Basics
Jason Horner, DigitalGlobe
Room 507 1:00 – 3:00 PM
This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, and how and when to use them. We will also look at some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging. Bring your toughest Dimensional Modeling quandaries.
Practical & Efficient SQL Performance Tuning
Vlado Barun, Oracle Corporation
Room 506 1:00 – 3:00 PM
Active Session History (ASH) and Automatic Workload Repository (AWR) represent a rich repository of performance statistics. But where do you start and how do you integrate these resources into a practical method for SQL performance tuning? Attend this session to learn how to rapidly determine and resolve root causes of SQL performance issues using ASH and AWR. We will use real production issues to demonstrate step-by-step how to resolve complex SQL performance problems. By the end of this deep dive, you will have gained a practical understanding of ASH and AWR and a set of SQL scripts to use in your own SQL performance tuning efforts.
Hadoop Internals for Oracle DBAs
Tanel Poder, Enkitec
Room 502/503 1:00 – 3:00 PM
In this session, we will take a deep dive into Hadoop, HDFS, and MapReduce internals from an Oracle database administrator’s perspective. We will explore the similarities and differences between a parallel query running on an Oracle RAC Database and a MapReduce job running on a Hadoop Cluster. This is not a high-level session talking about the future of big data, but a detailed look into Hadoop parallel processing and IO flow.
Certifying Application Performance on Exadata – A Real-World Case Study
Gaja Vaidyanatha, DBPerfMan LLC
Room 504 1:00 – 3:00 PM
Seems like yesterday, but Oracle Exadata is almost four years old. In its time, it has evolved as the preferred and quintessential database solution for large mission-critical Oracle systems and database consolidation efforts. This two-hour talk shares all relevant technical information pertaining to an application performance certification effort, performed for an ERP application suite on an Exadata X2 system. The presentation will delve deep into the details of the setup and configuration of the Exadata system, including but not limited to Oracle initialization parameters, storage layout, partitioning, parallelism, low-level application traces, relevant WebLogic configuration details and Oracle*Net optimizations. Bottom line is all technical decisions need to be driven by mathematical data not expert opinions.
NoSQL and Big Data for the Oracle DBA: Can RDBMS Handle the Performance, Scalability, and Availability Demands of a Wired World?
Room 501 1:00 – 3:00 PM
NoSQL and big data have a lot of momentum and even Oracle Corporation has joined the fray with its own NoSQL offering and Hadoop connectors. The NoSQL and big data camps claim that relational technology cannot handle the performance, scalability, and availability demands of a wired world. In this session, Iggy will demystify NoSQL and big data and survey the new product landscape. Iggy will then explain that the deficiencies of relational technology are actually a result of deliberate choices made by the relational movement in its early years. The relational camp needs to revisit these choices if it wants to compete with NoSQL and big data technologies in the area of performance, scalability, and availability. Iggy will:
• Demystify NoSQL using the example of Amazon Dynamo
• Compare the novel approach of Amazon with the conventional approach of eBay
• Survey the NoSQL and big data landscape, including the Oracle NoSQL solution
• Explain what makes relational technology so sacred
• Identify the missteps of the relational camp
Advanced ASH Architecture and Usage
Graham Wood, Oracle Corporation
Room 507 3:15 – 5:15 PM
Active Session History (ASH) was introduced with Oracle 10g and remains an important tuning and diagnostic tool today. Moving on from using ASH data to derive DB Time, we will look at how we can use ASH to get an estimate of average latencies for different events. This allows us to use ASH to better understand what sessions were doing in the past, allowing us to troubleshoot systems more effectively.
Combining Adaptive Cursor Sharing Flexibility with SQL Plan Management Stability
Carlos Sierra, Enkitec
Room 5c/d 3:15 – 5:15 PM
Adaptive Cursor Sharing (ACS) is known to offer multiple execution plans for a given SQL. This flexibility causes some plans to show and go over time. In most cases, this behavior is fine and unnoticed. SQL Plan Management (SPM) offers significant control over which execution plans can actually be used. With SPM, we obtain a high degree of plan stability. At first sight, it looks like ACS and SPM work on opposite directions. The former promotes plan flexibility and the latter plans stability. Both characteristics are very desirable. The question is: How do ACS and SPM work together? In this two-hour session, both ACS and SPM are explained and demonstrated in detail. You will learn how ACS actually works as well as some limitations that cause it to not be fully activated. You will also learn how to implement SPM so it can complement ACS. Using the duo ACS-SPM, you can benefit from both with plan flexibility and stability.
Data Science with Oracle Database
Alex Gorbachev, Pythian
Room 501 3:15 – 5:15 PM
This presentation is a practical introduction to data science for Oracle DBAs. We will use several public data sets as well as some of the typical Oracle performance data to apply some of the methods that data scientists are using these days. We will specifically focus on Oracle Data Mining and Oracle Enterprise R as well as Oracle Database 12c Pattern Matching.
Selectivity and How Oracle Calculates It
Jonathan Lewis, JL Computer Consultancy
Room 502/503 3:15 – 5:15 PM
This presentation explains the model (including weaknesses) that Oracle uses to calculate selectivity (fraction of data required) for many of the most common predicates. Understanding selectivity will help you when debugging bad SQL.