Deep Dive and Hands-On Sessions 2015

Register PresentationsButton presenter Button AGENDA-button SponsorsButton

Tuesday, February 17, 2015, Deep-Dive and
Hands-On Sessions

These sessions are included with the purchase of a full conference pass.

Deep-Dive Sessions  Hands-On Sessions




Deep-Dive Sessions

Error Management Features of Oracle PL/SQL
Steven Feuerstein, Oracle Corporation
Room 402/403         1:00 – 3:00 PM

Consistent, robust error management is a critical feature of any successful application. Developers need to know all that is possible in PL/SQL regarding the raising, handling, and logging of errors, and standardization of the way in which those tasks are performed.

This presentation takes you beyond the basics of exception handling in PL/SQL to explore the wide range of specialized error management features in Oracle. We will cover FORALL’s SAVE EXCEPTIONS, DML error logging with the DBMS_ERRLOG package, the AFTERSERVERERROR trigger, the DBMS_UTILITY.FORMAT_ERROR_BACKTRACE function, and more.

Back to top

Extreme Performance, Resiliency, and Monitoring of Improved GoldenGate 12c
Chaitanya Geddam, Accenture Enkitec Group

Room 404            1:00 – 3:00 PM

Oracle GoldenGate is a strategic data replication tool for many financial institutions. The growth patterns for data have changed drastically in the recent past, and replicating TB’s of data across WAN is a default norm with more complex computations and requirements. This presentation addresses the internals of GoldenGate replication and is a deep dive on performance tuning, WAN optimization in GoldenGate, process resiliency, and holistic view of GoldenGate monitoring. This presentation addresses easy and quick steps in making you an expert in using Oracle GoldenGate 12c core features along with providing expert insight on 10 things you would like to do to improve the performance of GoldenGate 12c.

This deep-dive exercise will cover:
1. Advanced tuning/troubleshooting of GoldenGate process lag
2. GoldenGate tokens, Event Marker system, and WAN optimizations
3. Oracle Integrated Extract, replicate, and coordinate replicate
4. Oracle redo stream, redo internals, and transaction internals
5. Eyes on glass monitoring, alerting, SNMP traps, and integration with OEM 12c

Back to top

Delivering Schema as a Service with Enterprise Manager
Pete Sharman, Oracle Corporation

Room 406            1:00 – 3:00 PM

Schema as a Service provides database consolidation by allowing administrators to host multiple application schemas within a single database. This offers Database as a Service to possibly hundreds of application users without creating database sprawl. Users can perform day-to-day actions such as provisioning, monitoring, and backup, all from a single self-service console. Schema as a Service leverages database features such as Resource Manager and Database Vault to isolate users of the cloud. This is complemented by metering and showback/chargeback capabilities, which provide visibility and transparency into resource consumption by each user.

This session walks through the setup and use of Schema as a Service with the Enterprise Manager 12c product suite.

Back to top

Oracle Optimizer: What’s New in Oracle Database 12c?
Thomas Kyte, Oracle Corporation

Room 407            1:00 – 3:00 PM

The Oracle Optimizer is one of the most fascinating aspects of the Oracle Database, as it is essential to the processing of every SQL statement. With each new release, the Optimizer evolves to take advantage of new functionality and the new information made available to it. Oracle Database 12c sees this evolution go a step further with the introduction of a new adaptive approach to query optimizations. This session gives a deep-dive explanation of how the new adaptive approach works. With the use of a real-world demo, we will examine the components of the adaptive model and show how they help the Optimizer learn additional information during query execution that can be used not only to improve the performance of the current SQL statement but all statements

Back to top

RAC 12c Optimization
Riyaj Shamsudeen, OraInternals

Room 4a            3:15 – 5:15 PM

Riyaj will introduce cache fusion concepts, block transfers, RAC wait events, gc buffer busy, etc. Then he will explain five golden rules of RAC diagnostics:

1. Top event tunnel vision
2. Eliminate infrastructure as an issue
3. Identify problem instance
4. Review send metrics, not just receive metrics
5. Use histograms, etc.

This will be an in-depth discussion as to how the resources are monitored and managed by RAC.

Back to top

Delivering Pluggable Database as a Service with Enterprise Manager

Pete Sharman, Oracle Corporation
Room 406      3:15 – 5:15 PM

With the introduction of Oracle Database 12c multitenant architecture, the latest consolidation model to look at is PDBaaS. A pluggable database (PDB), which can be described as portable sets of schemas, schema objects, and related structures that appear logically to an application as a separate database, provides enhanced database consolidation. Users can perform day-to-day actions such as provisioning, monitoring, and backup, all from a single self-service console. This is complemented by metering and showback/chargeback capabilities that provide visibility and transparency into resource consumption by each user.

This session discusses the setup and use of PDBaaS using the Enterprise Manager product suite.

Back to top

Deep Dive: Supercharge BI Delivery with Continuous Integration
Ace Director
Stewart Bryson, Red Pill Analytics

Room 407              3:15 – 5:15 PM

Raise your hand if you’ve heard this before: “It takes too long to deliver new content with OBIEE.” While in practice this statement is basically true, the goal of this presentation is to prove that it doesn’t have to be. Continuous Integration is the practice of automatically integrating, testing and deploying as part of the development process. One reason projects languish between design and delivery is that OBIEE doesn’t fit naturally into
this practice.

We’ll explore the use of cloud-based development combined with build automation and continuous integration techniques for testing and
deploying metadata and web catalog releases for OBIEE. Attendees will witness a live demonstration of multiple developers producing repository metadata content that is automatically tested and deployed.

Back to top

Hands-On Sessions

Achieve 10x, 100x, Even 1000x Performance Improvements – Without Upgrading Your Hardware
Vlado Barun, Oracle Corporation

Room 401            1:00 – 3:00 PM

Fact #1: Data Volumes are ever-increasing. Fact #2: Performance SLAs are becoming more demanding. Are hardware upgrades the only solution? The answer is definitely NO. With the right combination of programming techniques and DB feature usage, you can improve the performance of your database (and related applications) by 10x, 100x, even 1000x. However, with so many different DB features and approaches to coding, where do you start? Furthermore, how do you identify the bottlenecks in your database/application? This presentation consists of a live demo on how to approach a real-world performance problem. We will work together to identify the bottleneck(s), evaluate candidate solutions, and measure the performance/scalability impact of the chosen solution. Prerequisites: basic understanding of Oracle DB architecture, wait events, AWR, and ASH.

Back to top

Hands-On with Oracle Mobile Cloud Service and Mobile Application Framework
Joe Huang, Oracle Corporation

Room 405             1:00 – 3:00 PM

If you are interested in learning how to develop mobile applications and services, this is the hands-on lab for you. You will define a back-end service, define the application, and deploy your application, all from a browser. This session will give you a chance to directly work with Oracle Mobile Cloud Service and Mobile Application Framework to create sophisticated mobile applications and host them with a back end without writing any code.

Back to top

Build Mobile ERP Applications Using Oracle MAF
Bruce Bailey, Oracle Corporation
Room 401           3:15 – 5:15 PM

Important Prep Instructions/Checklist for RMOUG Mobile ERP Hands-On Session

Greetings to everyone attending my RMOUG Hands-On Session!  My name is Bruce Bailey and I am looking forward to being your instructor on the afternoon of February 17th.  I wanted to send out these critical prep instructions for the Build Mobile ERP Applications Using Oracle MAF in order to ensure that we have a productive afternoon. 

If you have trouble or questions on any of this don’t hesitate to email me or call me directly.
Bruce Bailey    303-638-4197

Laptop Requirements
Everyone attending needs to bring their 8GB Windows 7 laptop with JDeveloper and the Android SDK pre-installed and configured.  The setup will take about an hour, and must be done beforehand as there will not be time to setup or troubleshoot during the lab itself.  Instructions for the prep can be found at the following link:

Laptop Prep Office Hours – Personal setup assistance
I will be available to personally assist with the lab’s mobile development setup for anyone who gets stuck or wants to be walked through the process.  Bring your Windows 7 laptop along.  Also, it would be helpful to let me know if/when you will be stopping by, though certainly not mandatory.

Where:  Oracle DTC Office, Building 2, 6th floor, 7604 Technology Way, Denver, CO 80237 (call Bruce at 303-638-4197 from the building lobby when you arrive)
When:  Friday, February 13th, Noon to 5:00 PM and Monday, February 16th, 9:00 AM – 5:00 PM

Lab Guides
RMOUG is paperless, though I recognize that toggling between .pdf instructions and an IDE during a time-constrained development exercise is challenging for most people.  If your preference is to have hardcopy instructions during the exercises then download the guides (there are 2 of them since it is a 2 part lab) and bring them along.

Bring your own Android Device for Testing
If you don’t have your own Android device, don’t worry – the lab setup includes Google’s Android Emulator.   On the other hand, if you have an Android tablet or phone bring it along!  Be sure to bring your USB cable too and make sure you have installed a file manager on your device beforehand.   I use ES File Manager and find that it works well.

That’s it and again, don’t hesitate to email or call me with any questions regarding the lab prep!

During this interactive workshop, participants will understand key elements of an enterprise mobility platform and hear technical requirements for enterprise applications. Attendees will learn Oracle’s mobile reference architecture and solution patterns and see how these concepts come together via a mobile order management demonstration. The agenda includes an optional hands-on portion to allow participants to experience development firsthand. Participants will use Oracle Mobile Platform to build a mobile application front end to a live instance of Oracle E-Business Suite for the purpose of processing expense approvals. Although E-Business Suite is used for the labs, the lessons learned apply to PeopleSoft, JD Edwards, Siebel, or any backend application. Participants will also see how the same code base can be used to deliver both iOS and Android applications. No prior experience with the Oracle Mobile Platform is needed.

Back to top

Oracle Application Development Framework in a Nutshell
Peter Koletzke, Quovera
Room 402/403       3:15 – 5:15 PM

Installation Prerequisites

It is essential to have a copy of JDeveloper 12c and an Oracle database (any version) installed on your laptop beforehand so you can take advantage of the full time of the session for completing the hands-on steps. Please follow these preparation steps even if you think you have the necessary installations:

Download and unzip the following file:
Open install_requirements.txt, and check the installation requirements; also follow the steps in the “Preparation Step” section.

You will also see a ReadMe.txt file but you can ignore it until the session. If you have any questions about the installation prerequisites, please email

Complex web and mobile enterprise applications in the Oracle arena will most probably at some point incorporate Java frameworks. A case in point is Oracle Fusion Applications, developed in a Java-oriented framework called Oracle Application Development Framework (ADF). This very large application suite requires the power and flexibility of Java and its related technologies.

You may have a good handle on other development disciplines such as APEXbut need to round out your knowledge with a basic understanding of how Java applications are created using a tool such as ADF.

This hands-on session will get you up and running with that basic knowledge. It focuses on creating an application that is designed for use either in a mobile tablet or desktop environment. The session will introduce you to the core technologies needed to build an ADF application: ADF Business Components, ADF Faces, and ADF Controller. Half of this all-day session will consist of hands-on labs where you can experience and practice basic application development the ADF way. You will create interfaces that perform all major database operations and practice various layout and data presentation styles.
Back to top

Essbase Studio – Oracle’s One-Stop Shop
Marc Weinzimmer, The Bean Consulting Group

Room 404   3:15 – 5:15 PM

Essbase Studio streamlines cube construction by delivering a single environment for performing tasks related to data modeling, cube designing, and analytic application construction. By consolidating these activities, Essbase Studio provides a consistent platform for building outlines and loading data.

With a wizard-driven user interface, Essbase Studio supports modeling various data source types. A common metadata repository captures all metadata related to all Essbase applications built and allows the reuse of metadata at the lowest level of granularity. Essbase Studio supports several drill-through options, and functionality is supported from data cells and is dynamically linked to cubes with matching metadata context. Essbase Studio also supports lineage tracking through a rich graphical view of the metadata relationships, allowing users to follow application lineages to their metadata components and through to the data sources from which they were sourced.

Essbase Studio is the future of data analytics and will quickly overshadow previous Oracle BI tools, such as Essbase Integration Services and Essbase Administration Services Console. This hands-on presentation will walk you through the process of implementing Essbase Studio to navigate complex data across all levels of your business.

Back to top

Hands-On Lab: Oracle BI Mobile Application Designer

AceChristian Screen, Art of BI Software
Room 405      3:15 – 5:15 PM

This is a hands-on lab session which gives participants a walk through of how to develop mobile applications using the Mobile Application Designer interface of Oracle BI 11g. By the end of this session users will have completed the development of a mobile application from the ground up, deployed it into a production-ready state, and tested the mobile app via the Oracle BI dashboards and mobile device. Participants are encouraged to bring their own mobile tablets and also their own laptops.

Back to top