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||Database Administration||DBA Deep Dive||Hyperion|
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 505 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 502/503 1:00 – 3:00 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.
Demystifying MySQL for Oracle DBAs and Developers
George Trujillo, Hortonworks
Room 1a 3:15 – 5:15 PM
MySQL continues to be the world’s most popular database management system for the Internet and the cloud. This detailed technical session provides a fast-paced introduction to the MySQL architecture, core features, best practices, core parameters, and key performance metrics. We will discuss the MySQL version of the Optimal Flexible Architecture (OFA) standard as a best practice and teach MySQL features from a perspective that is easy for Oracle DBAs and developers to understand. Attendees will learn the role of MySQL in Hadoop infrastructures.
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.
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 and John Beresniewicz, 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 502/503 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.
Compression in Oracle Database
Tim Gorman, Evergreen Database Technologies
Room 1c/d 3:15 – 5:15 PM
There are several different types of compression available in the Oracle database for compressing table data, and so the question must arise: Which are most appropriate, and for which purpose? This presentation will discuss all the different types of table data compression in Oracle database (i.e. basic/advanced de-duplication compression and hybrid-columnar compression) as well as some older, often-forgotten techniques for fitting more data into less space. The presentation will begin with a brief review of data compression in general, followed by a review of the formats used for storage in database blocks and rows, the latter supported by block dumps. All of this will be a prelude for a knowledgeable discussion of the advantages and disadvantages of each type of table compression in Oracle.
Selectivity and How Oracle Calculates It
Jonathan Lewis, JL Computer Consultancy
Room 504 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.
Introduction to Java and the Essbase Java API + Next Generation Essbase Outline Extractor Tips and Tricks
Tim Tow, Applied OLAP
Room 501 3:15 – 5:15 PM
Double your knowledge during this two-hour session. Over the years, many Essbase customers and partners have customized their applications with the Essbase Visual Basic, or “VB” API. As Microsoft support for VB ended over eight years ago, the writing is on the wall for those customers still running applications written using the VB API. The logical choice for building modern applications on the Essbase platform is Java and the Essbase Java API. Learn the basics of how to get started with the Java programming language and the Essbase Java API.
Once you have a basic understanding of what the Essbase Java API can do, see how it has been used to provide new capabilities in the Next Generation Outline Extractor. The free Next Generation Outline Extractor utility is the follow-up to the classic OlapUnderground Essbase Outline Extractor used by thousands of Essbase customers.