Deep-Dive and Hands-On Sessions 2015
Tuesday, February 17, 2015, Deep-Dive and
These sessions are included with the purchase of a full conference pass.
|Deep-Dive Sessions||Hands-On 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.
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
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.
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
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.
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.
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.
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.
Build Mobile ERP Applications Using Oracle MAF
Bruce Bailey, Oracle Corporation
Room 401 3:15 – 5:15 PM
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.
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.
Hands-On Lab: Oracle BI Mobile Application Designer
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.
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.