Deep-Dive and Tech-Tip Sessions 2017

PresentationsButton presenter Button AGENDA-button SponsorsButton

Tuesday, February 7, 2017, Deep-Dive and
Tech-Tip Sessions

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

Deep-Dive Sessions  Tech-Tip Sessions




Deep-Dive Sessions

Building Oracle Applications Using Modern Application Development Techniques and Frameworks
Mark Drake, Oracle Corporation
Room 1c            1:00 – 3:00 PM

This tutorial explains how to use modern development techniques and frameworks to build applications that take full advantage of JSON. It introduces Simple Oracle Document Access (SODA), a family of APIs that makes it easy for developers to use Oracle Database 12c as their JSON document store. It will show how SODA delivers the NoSQL application development experience, allowing developers to develop, deploy, and maintain their applications without learning SQL or needing support from Oracle DBAs. 

The tutorial demonstrates storage and retrieval of JSON documents as well as simple searches, full-text searches, and locality searches using a simple application for purchasing movie tickets. It shows how SODA makes it easy to combine the power and flexibility of HTML, JavaScript, and JSON with the security, scalability, reliability, and availability of the Oracle Database. The tutorial presents two REST-based front ends, one using HTML5, JavaScript combined with JQuery, Bootstrap, and Angular.js, and the other using HTML5, JavaScript and OracleJET. It also presents two middle-tier architectures, one using Node.js that combines JavaScript with popular node.js modules, such as express.js and request.js and uses SODA for REST to communicate with the document store. The second is written in Java and uses SODA for Java to communicate with the document store.

Finally, we will see how choosing Oracle 12c ensures we have access to the full power of SQL when performing query and analytics on our JSON documents. The tutorial introduces exciting new JSON-related features delivered as part of Oracle Database 12c Release 2.

Back to top

Agile Methods and Data Warehousing: How to Deliver Faster
Kent Graziano, Snowflake Computing

Room 1f            1:00 – 3:00 PM

Most people will agree that data warehousing and business intelligence projects take too long to deliver tangible results. Often by the time a solution is in place, the business needs have changed. With all the talk about Agile development methods like SCRUM and Extreme Programming, the question arises as to how these approaches can be used to deliver data warehouse and business intelligence projects faster. This presentation will look at the 12 principles behind the Agile Manifesto and see how they might be applied in the context of a data warehouse project. The goal is to determine a method or methods to get a more rapid (2-4 weeks) delivery of portions of an enterprise data warehouse architecture. Real world examples with metrics will be discussed.

Back to top

RAC Cache Fusion Internals and Performance Tuning RAC Wait Events
Riyaj Shamsudeen, Orainternals
Room 1c            3:15 – 5:15 PM

In this presentation,  I will introduce how cache fusion internally works and how various layers and GCS locks maintain the consistency of database blocks in multiple instances. I will map these internals to specific RAC wait events and performance statistics.

Continuing the internals, we will understand how to use the newly gained knowledge to troubleshoot RAC performance issues. We will explore how to reduce the impact of RAC wait events. Then, we will dive further into a few tips and tricks to quickly troubleshoot performance issues in a RAC database.

Back to top

Programming with Collections
Steven Feuerstein, Oracle Corporation
Room 1f            3:15 – 5:15 PM

Collections (array-like structures in PL/SQL) are critical data structures that are used in some of the most important features of PL/SQL. Every PL/SQL developer should have a deep familiarity with collections and the wide range of features that Oracle has implemented for them over the years. This session introduces collections and quickly moves on to detailed explanations of collection methods, how to leverage string indexing in associative arrays, multi-level collections, set-level operations on nested tables, and more.

Back to top


Tech-Tip Sessions

Introduction to Oracle’s Low-Code Development Platform
Shay Schmeltzer

Room 1a            1:00 – 1:30 PM

Is your IT organization struggling to meet business users’ needs? Can’t deliver needed applications fast enough? Come to this session to see how new tools transform the way applications are created and hosted, empowering business users to become self-sufficient and reducing the workload on IT departments. Learn how IT and users can collaborate to create an ecosystem that accelerates time to market for new apps.

Back to top

Oracle PL/SQL Secure Coding Practices
Robert Lockard

Room 1b          1:00 – 1:30 PM

This is a 30-minute session that is an expansion to the “Holistic Database Security” presentation.

We will examine common errors in PL/SQL that lead to SQL injection attacks. This session will define the SQL injection attack vector and various ways to write code that is immune to SQL injection.

– We will be covering application architectures that separate data from code.
– We will be covering Oracle PL/SQL 12c features that limit access paths to data, thereby implementing part of the trusted path.
– We will also be covering other PL/SQL features from before 12c that help to ensure your PL/SQL does what you expect it to do.

Back to top

Horsepower: The Sizing and Scaling of Hyperion to OBIEE Conversion
Jason Dimmer, Arisant

Room 1a            1:45 – 2:15 PM

When comparing systems, one must look holistically at the underlying IT architecture. This may drive an architecture change to adequately compensate and balance “horsepower” to a new system.

An approach of just reviewing the Hyperion reports to capture the baseline data elements is not adequate. One must review report levels, business logic, and IT infrastructure. Maintaining the underlying rules with different technologies can induce a direction change within the development lifecycle.

Back to top

Deploying Oracle 12c DB and Applications in LXC Linux Containers
Gilbert Standen, Stillman Real Consulting LLC
Room 1b            1:45 – 2:15 PM

Learn how to deploy fully supported Oracle 12c RAC and standalone databases in LXC Linux containers, which are now fully supported by Oracle Corporation for Oracle database deployments on Oracle Linux 6 and 7 Linux distribution for UEK3 and UEK4 kernels. The presentation includes practical tips and tricks and SLOB performance comparison charts of bare metal vs. VM vs. LXC container for metrics such as latency and throughput. The presentation explains how Linux containers allow consolidation of disparate systems all on the same hardware, including big data, NoSQL, Hadoop, Hive, Cassandra, Spark, MySQL, and others, while preserving SLAs and QoS guarantees.

Back to top

DOP: How Much is “Enough”?
Randy Cunningham, SageLogix

Room 1a            2:30 – 3:00 PM

Often, degrees of parallelism are set to high values, sometimes based on antiquated “rules of thumb.” The result is slower performance than if SQL parallelism were not used at all!

Find out in this presentation how to determine optimal DOP (degrees of parallelism) and what the best methods are for ensuring that DOP consistently helps throughput rather than worsening it.

Back to top

Benefits, Enrollments, and More Benefits! From Legacy to Oracle
Chuck Fay, AST Corporation
Copresenter: Keith Velilla, AST Corporation
Room 1b        2:30 –3:00 PM

Are you converting benefits into Oracle R12 Advanced Benefits for an implementation or a conversion and don’t have the time, expertise, or money to write the code and all of the API’s necessary to do so? Did you know there is another way that involves functional staff with minimal interaction with the technical team? This presentation will go through all of the steps necessary for a benefits conversion using the seeded Oracle Configuration Workbench tools. From pre-conversion steps such as the creation of Action Parameters for Data Pump, the setting of Max Errors, and temporary OAB setups to actual conversion steps such as running Administrative Life Event and using the Configuration Workbench, this session has it all. We will also share lessons learned from our most recent conversion and nuances that make each conversion slightly different.

Back to top

Make Services Work for You: Stop Missing Out
Ace Director
Bjoern Rost, Pythian
Room 1a            3:15 – 3:45 PM

Introduced with Oracle 8i, services are becoming more and more useful with every new version of the Oracle Database. Yet many users are missing out on many great features that a proper implementation of services can provide. Learn how to use services to get a head start into monitoring and resource management, provide flexibility for maintenance and migrations, and unlock the full potential of RAC and Data Guard deployments in terms of manageability and availability.

Back to top

Segregation of Duties and Auditing: Necessary Evil or Good Business Practice?
Vrinder Randhawa, Q Software Global Ltd
Room 1b           3:15 – 3:45 PM

Making sure your audit controls are sustainable and robust is the latest paradigm for internal controls. During this 30-minute presentation, we will elucidate and educate about the systems we see in the market, how these are augmented and improved over time, and what this means to you if you’re embarking on improving or implementing your internal controls.

Back to top

Exadata for Developers: Stop Driving Your Ferrari in the Parking Lot!
Greg Garretson, Raymond James via Eagle Datagistics

Room 1a            4:00 – 4:30 PM

Exadata is truly the Ferrari of databases. It is an extremely powerful machine capable of incredible performance. However, I often find that its potential is not being used by many Oracle developers with a commodity database background. The goal of this session is to provide Oracle developers working on Exadata systems with Exadata best practices they can take to work the next day and begin to immediately improve performance on their system. After all, a 500 HP Ferrari is meant to be driven on the Autostrada, not in a parking lot.

Back to top

How to Structure Persuasive Presentations
Charles Knapp, Quest International Users Group

Room 1b            4:00 – 4:30 PM

Everyone gives presentations, from short verbal updates in staff meetings to speaking before public audiences such as at Collaborate and OpenWorld. How do you make the most of your speaking time?

In this brief presentation, you will learn proven principles of persuasion:
1. The one thing your presentation needs most
2. Why less is more
3. How to structure your story for results

Back to top

Best Practices for Migrating Your Legacy RDBMS to My SQL and the Cloud
Julie Hyman, Quest Software

Room 1a            4:45 – 5:15 PM

As business drives your IT organization to evolve toward a more hybrid approach to database platforms and their management, you’re undoubtedly finding complex challenges along the way. In this session, product manager Julie Hyman will unpack your options for cutting costs by moving to Open Source RDBMS technologies and/or the cloud, and how to exploit those technologies to achieve maximum benefit. She will share top reasons to migrate and some decision-making factors that will influence your decisions. Finally, Julie will discuss ways to ease the pain of migration and how to get the most out of your investment once you’ve migrated a portion of your database to the cloud or a new database platform.

Back to top

Only the Gorillas are Naked
Laura Ramsey, Oracle Technology Network

Room 1b           4:45 – 5:15 PM

Success in the high-tech industry is not about being smart, although that always helps. It’s about radical inclusion and fearless participation. Learn the four things that might be killing your ability to create and innovate. This presentation has some code. And pictures of gorillas, masks, and aerialists – not in that order.

Back to top