Database

Track sponsored by:

Database Administration and Development at the ODTUG Kscope17 Conference

Oracle Database is core to the ODTUG Kscope17 conference and the backbone for every application, solution, and product in the Oracle suite. Kscope17 will bring together the world’s best Oracle ACE Directors, ACEs, ACE Associates, Database Administrators, and Developers to present the latest tools, tips, tricks, hacks, and techniques.

ADF and MAF:

Learn about top database modeling features and REST API strategy, make back-end to front-end cloud connections, develop applications using Application Development Framework (ADF) and Mobile Application Framework (MAF), test drive Oracle 12c, and deep dive into Oracle VM along with shortcuts using tools such as Ansible, Vagrant, and Docker. Kscope17 is the best conference to learn next-generation tips along with performance and database security optimization tricks. 

Database Administration:

We’ll tackle all the latest Database Administration and Oracle Database 12c features, concepts, and techniques of Oracle Enterprise Manager and Database 12c. Topics can cover backup and recovery, security, hardware, software administration, identity management, high availability, performance tuning, upgrades, consolidation, storage, cloud, virtualization, scripting, multitenant, in-memory, database as a service, and auditing. 

Database Development:

Database development concepts and techniques that include application architecture, data modeling, database design, application design, SQL, PL/SQL, testing, debugging, logging, ETL, 12c new features, version control, application performance, open source APIs, cloud based development, programming languages and frameworks to interface with database environments. 

Database Tools:

Want to learn about the latest tools that make developers’ lives easier? We’ll cover all the best database tools used for interfacing with database environments. Topics covered SQL Developer, SQL Developer Data Modeler, SQLcl, OraOpenSource (OOS), TOAD, DBArtisan, and more.

DevOps/Agile:

DevOps is a philosophy or approach that enforces the collaboration and communication between software developers and IT operations by automating the process of software delivery and infrastructure changes. Learn operational strategy, development and review to code merging, integration, testing, change management release approvals, and release automation configuration. You’ll learn about infrastructure and management, infrastructure as code, end-user experience, and application performance monitoring.

Check out the presentations listed below.



Look Inside the Locking Mechanism
Liron Amitzi , DBAces
When: Jun 28, 2017, Wednesday Session 13, 11:15 am - 12:15 pm
Room: Begonia
Topic: Database - Subtopic: Other Database

Locking issues have always been an interesting topic. This is one of the most important features that maintain the integrity of our database.

Why do we need the locking mechanism? What locking modes and types are there? What does Oracle lock during DML and DDL operations? How are constraints and indexes affected by and affecting locks? These are some of the questions this session handles. It also includes live demos for some advanced and interesting scenarios and shows how to query relevant data dictionary views.

Back to Top
SQLcl: A Modern Command Line Interface to the Oracle Database
Galo Balda , State of Texas
When: Jun 26, 2017, Monday Session 3 , 2:00 pm - 3:00 pm
Room: Verbena/Periwinkle
Topic: Database - Subtopic: DB Tools

SQLcl is a Java-based command line interface that takes advantage of SQL Developer’s scripting engine to deliver a modern command line interface that is backward compatible with SQL*Plus but also introduces new commands and usability enhancements that have been missing for a long time. Come to this session to see a demo showing the new inline editor, query history, aliasing, result formatting, DDL generation, JavaScript support, and other exciting features that set SQLcl apart from its predecessor.

Back to Top
IoT to the Database: Soldering, ORDS, Oracle Jet, Python and a Little PL/SQL
Blaine Carter , Oracle Corporation
When: Jun 26, 2017, Monday Session 1 , 10:30 am - 11:30 am
Room: Begonia
Topic: Database - Subtopic: DB Tools

If you're like me, you use way too much power and you’re not quite sure where. Tracking your power usage is a great start, but analyzing the data is often easiest when it's in a database. Having to type it in by hand would be a pain; let's void a warranty instead!

Back to Top
Hands-On Lab: Building an Oracle Database Web Application with Oracle JET and ORDS
Ashley Chen , Oracle Corporation
Co-presenter(s): Jeff Smith, Oracle Corporation
When: Jun 27, 2017, Hands on Lab Session 6, 8:30 am - 9:30 am
Room: Goldenrod
Topic: Database - Subtopic: Other Database

Participants will learn how to develop and deploy a RESTful Service using Oracle SQL Developer, Oracle REST Data Services, and Oracle Database.
Then we'll show how to connect these services as data sources to a few different Oracle JET Visualization components to quickly build rich HTML5 applications using our free and open source JavaScript framework.
Prerequisite: Participants need to bring their laptop with our Oracle Developer Days VM already installed. The VM is available on June 12th for download (http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html). Please review the instructions on how to setup the VM here: http://www.oracle.com/technetwork/developer-tools/rest-data-services/learnmore/how-to-setup-vm-3745567.pdf.

Back to Top
The Future of Database
Maria Colgan , Oracle Corporation
When: Jun 27, 2017, Tuesday Session 6 , 8:30 am - 9:30 am
Room: Begonia
Topic: Database - Subtopic: DBA

Database architectures are fundamentally changing due to new technologies and new requirements. Organizations must understand and embrace these transformations to thrive in the future. This has never been more evident than with Oracle Database 12c, which has been the most rapidly adopted release in over a decade. This session provides a technical introduction to what's new in Oracle Database 12c and explains how you can embrace each transformation while preserving your existing investments.

Back to Top
Explaining the Explain Plan: Interpreting Execution Plans for SQL Statements
Maria Colgan , Oracle Corporation
When: Jun 28, 2017, Wednesday Session 12 , 9:45 am - 10:45 am
Room: Bluebonnet/Dogwood
Topic: Database - Subtopic: DB Dev

The execution plan for a SQL statement can often seem complicated and hard to understand. Determining if the execution plan you are looking at is the best plan you could get or attempting to improve a poorly performing execution plan can be a daunting task, even for the most experienced DBA or developer. This session examines the different aspects of an execution plan, from selectivity to parallel execution, and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan.

Back to Top
Oracle 12cR2 Database In-Memory: Adventures with SwingBench TPC-DS
Jim Czuprynski , ViON Corporation
When: Jun 28, 2017, Wednesday Session 11, 8:30 am - 9:30 am
Room: Begonia
Topic: Database - Subtopic: Other Database

Originally introduced in Release 12.1.0.2, Database In-Memory (DBIM) offers the ability for analytic queries to sift through billions of rows at incredible speed because data is now retained in columnar format in the In-Memory Column Store (IMCS). Oracle Database 12cR2 dramatically expands the capabilities of DBIM, making it even simpler to implement, monitor, and manage while extending its reach to more complex execution plans, expanding its utility to Active Data Guard (ADG) instances, and enabling capture of frequently-evaluated expressions in the Expression Statistics Store (ESS).

Session Outline:
Through presentations and examples using Swingbench’s latest TPC-DS query generation features, this session will illustrate how Oracle 12.2 Database In-Memory:
- dramatically speeds execution of analytic queries through In-Memory Column Store (IMCS)
- improves the management and monitoring of the IMCS
- improves complex query execution through improvements like Expressions Statistics Store, In-Memory Filtering, and Parallel Execution

Back to Top
Regression Analyzed, Tout de Suite: Leveraging Oracle 12c Database’s Real Application Testing (RAT) Suite
Jim Czuprynski , ViON Corporation
When: Jun 28, 2017, Wednesday Session 15 , 3:00 pm - 4:00 pm
Room: Begonia
Topic: Database - Subtopic: DB Tools

In the seven years since Oracle released the Real Application Testing (RAT) suite as part of release 11.1.0.7, this powerful set of diagnostic tools has received significant upgrades. This session will illustrate how the latest version of RAT in Oracle Database 12.1.0.2 is still a primary contender in the battle to identify potential bottlenecks in application performance before any database is migrated / upgraded to a newer version. We will offer some real-world examples of how to best to leverage RAT’s several new features in 12.1.0.2, including Workload Intelligence, Workload Scale-Up, and Consolidated Database Replay, as well as its original key features – Database Capture and Replay (DBCR) and SQL Performance Analyzer (SPA) - to avoid unnecessary application performance regression, especially when transitioning to Oracle Database 12c.

Through presentations and online demonstrations, this session illustrates how to:
- capture replayable database application performance baselines with RAT Database Capture and Replay
- determine which SQL statements will unquestionably experience performance regression during execution
- leverage the latest hooks to Oracle’s built-in tuning advisors to generate improved execution plans before migrating or upgrading your database to the next release

Back to Top
Open Source PL/SQL Utility Tools for Oracle
Martin D'Souza , Insum Solutions
When: Jun 28, 2017, Wednesday Session 14 , 1:45 pm - 2:45 pm
Room: Verbena/Periwinkle
Topic: Database - Subtopic: DB Dev

OOS Utils is a free open-source PL/SQL tool set for common utility functionality that developers use. Its goal is to prevent developers from having to rewrite the same code over and over again.

This presentation will highlight some of the great features of OOS Utils and showcase some future plans for the project. All audience types (DBAs, PL/SQL and APEX developers, and development managers) are encouraged to attend, as all will see immediate benefits for themselves or their teams to use.

Back to Top
Database Sunday Symposium Session 3
Colm Divilly , Oracle Corporation
When: Jun 25, 2017, Sunday Symposium Database Session 3, 1:00 pm - 2:45 pm
Room: Cibolo Canyon 8/9/10
Topic: Database - Subtopic: Other Database

Session 3: 1:00 PM - 2:45 PM

ORDS REST Development Flexibility
Jeff Smith, Oracle Corporation
You have a lot of options when it comes to exactly how you want to REST 'enable' something in the database.

SQL Magic: The Cups and Balls Trick
Chris Saxon, Oracle Corporation
In this talk Chris does a SQL take on the classic "cups and balls" magic trick. But, unlike real magicians, he'll show you how it's done so you can do your own SQL magic at work!

How to Protect the Crown Jewels
Maria Colgan, Oracle Corporation
Companies across the globe keep everything from their customer’s information to their financial results in databases, effectively making databases the keeper of the companies' crown jewels. But how secure are they? This session will examine the techniques deployed to protect the British crown jewels and explain how you can deploy similar strategies to keep your company's crown jewels safe.

Welding Together REST APIs
Colm Divilly, Oracle Corporation
Colm will describe how to securely combine disparate REST APIs in a single web app by leveraging the Cross Origin Request Sharing (CORS) protocol.

Building Your Own Oracle Developer Day VM
Barry McGillin, Oracle Corporation
Barry will show how the VM is built automatically with VirtualBox and what you use it for. SQL sandbox, Apex Sandbox, Ords sandbox. The choice is yours.

Back to Top
Deploying REST Services at Scale
Colm Divilly , Oracle Corporation
When: Jun 26, 2017, Monday Session 2 , 11:45 am - 12:45 pm
Room: Bluebonnet/Dogwood
Topic: Database - Subtopic: Other Database

REST powers the Oracle Cloud. From how customers build and deploy REST services, to how the cloud itself is built. This session will cover how Oracle REST Data Services is deployed in the Oracle Public Cloud at scale. This includes auto configuration for adding capacity on demand, security, tiered architecture, and lots more.

Back to Top
REST Enabling the Oracle Database
Colm Divilly , Oracle Corporation
When: Jun 28, 2017, Wednesday Session 16 , 4:15 pm - 5:15 pm
Room: Azalea
Topic: Database - Subtopic: DB Dev

This session will demonstrate how quickly one can install and configure Oracle REST Data Services (ORDS) to provide/serve REST endpoints on both RESTful Services and Database Objects themselves.

A brief overview of REST concepts will be followed by a demo of ORDS being installed in less than 5 minutes.

Then a series of demos showing how easy it is to REST enable a table and use GET/POST/DELETE to provide a full CRUD API to your data, including complex scenarios involving complex data types like SDO_GEOMETRY and rich web applications that can take advantage of JSON.

REST is the new development paradigm and the Oracle Database is 100% ready with the addition of ORDS.

Back to Top
Alexa! How Do You Work with Oracle REST Data Services?
Jonathan Dixon , JMJ Cloud
When: Jun 27, 2017, Tuesday Session 7 , 11:15 am - 12:15 pm
Room: Bluebonnet/Dogwood
Topic: Database - Subtopic: Other Database

At first glance, Artificial Intelligence (AI) may seem beyond the reach of the citizen ORDS developer. With companies such as Amazon, Google, and Apple providing the interface (aka Alexa, OK Google, and Siri), however, this is no longer the case. In this session, I will demonstrate how you can use Oracle REST Data Services (ORDS) as the gateway to and the Oracle Database as the engine behind Alexa skills that will impress your customers. Alexa! How many orders were placed in the past hour? Alexa! Are there any stuck transactions in ERP Cloud? Alexa! It's time to make ORDS and the Oracle Database cool!

Back to Top
45 Most Useful New DBA Commands in Oracle 12.2
Julian Dontcheff , Accenture Enkitec Group
When: Jun 27, 2017, Tuesday Session 9, 3:30 pm - 4:30 pm
Room: Azalea
Topic: Database - Subtopic: Database Design

As beta tester of 12cR2, I was trying to list and isolate the most interesting and rather important new features of the release from a DBA point of view. This presentation will cover the most important 45 new features along with a command representing the feature in 45 slides.

Back to Top
Exploring Advanced SQL Techniques Using Analytic Functions
Zohar Elkayam , Brillix-DBAces
When: Jun 28, 2017, Wednesday Session 11, 8:30 am - 9:30 am
Room: Bluebonnet/Dogwood
Topic: Database - Subtopic: DB Dev

Even though DBAs and developers are writing SQL queries every day, it seems that advanced SQL techniques such as multidimension aggregation and analytic functions still remain relatively unknown. In this session, we will explore some of the common real-world usages for analytic function and understand how to take advantage of this great and useful tool. We will deep dive into ranking based on values and groups, understand aggregation of multiple dimensions without a group by, see how to do inter-row calculations, and much more.

Together, we will see how we can unleash the power of analytics using Oracle 11g best practices and Oracle 12c new features.

Back to Top
Hands-On Lab: Oracle Dev Gym PL/SQL Workout - Oracle Database 12c
Steven Feuerstein , Oracle Corporation
When: Jun 26, 2017, Hands on Lab Sessions 3-4, 2:00 pm - 4:15 pm
Room: Goldenrod
Topic: Database - Subtopic: DB Dev

The hands-on lab "Oracle Dev Gym PL/SQL Workout - Oracle Database 12c” will consist of a series of quizzes to be taken by attendees. Steven Feuerstein will then explore the PL/SQL features covered in each quiz. To make the best use of your time together, Steven asks that you (a) make sure you have an Oracle account set up and (b) visit https://devgym.oracle.com to set up your profile and explore the site. Be sure to provide an identifiable Gym Name (by default it will be set to USER45675 or something like that) - because if you are smart enough and lucky enough to get a high-ranking score on your quizzes, you will win a prize. But anonymous players will *not* be rewarded! And anyway Kscope is not the place for anonymity. It’s the place for building networks and community. :-)

Note: you do not need to be an experienced PL/SQL programmer or know anything about Oracle Database 12c new features. It’s all about developing expertise through exercise!

Back to Top
Optimizing PL/SQL for Performance and Maintainability
Steven Feuerstein , Oracle Corporation
Co-presenter(s): Bryn Llewellyn, Oracle Corporation
When: Jun 27, 2017, Tuesday Session 8 , 2:00 pm - 3:00 pm
Room: Bluebonnet/Dogwood
Topic: Database - Subtopic: DB Dev

After fully leveraging SQL in your Oracle Database applications, it’s time to completely utilize PL/SQL to implement business rules, create APIs on top of your data structures, and implement key processes within the database. Usually when developers think about optimization, they focus on performance, and this session does too. But it’s also critical to think about how to write code today so that tomorrow and years from now, future developers will be able to adapt that code to changing user requirements and database features. In this session, PL/SQL experts, including Bryn Llewellyn and Steven Feuerstein, will present their ideas on writing optimal PL/SQL but focus mainly on answering questions from the audience.

Back to Top
Change Impact Analysis with 12.2 PL/Scope
Steven Feuerstein , Oracle Corporation
When: Jun 28, 2017, Wednesday Session 16 , 4:15 pm - 5:15 pm
Room: Bluebonnet/Dogwood
Topic: Database - Subtopic: DB Dev

PL/Scope, first introduced in 11.1, offers a powerful code analysis tool, baked right into PL/SQL. With it, you can answer questions such as, "Where is this variable modified in my code?" "Which packages invoke a specific overloading of a function?" and "Show me all my unused declarations." Cool stuff. But prior to 12.2, SQL statements were not a part of that analysis. Now in 12.2, PL/Scope also gathers information about static SQL statements and where dynamic SQL is executed in your code. As a result, you can now use PL/Scope to perform comprehensive, detailed analysis of the impact of planned changes to your code base. In this session, Steven Feuerstein introduces attendees to PL/Scope, explores 12.2 enhancements, and provides scripts everyone can use to leverage PL/Scope in their dev environment.

Back to Top
Updatable Views to Secure Your Database and Make Your Developers Happy
John Flack , John C. Flack
When: Jun 26, 2017, Monday Session 1 , 10:30 am - 11:30 am
Room: Azalea
Topic: Database - Subtopic: DB Dev

Learn about the advantages of putting updatable views between your applications and your tables. They can simplify development, enforce business rules, and provide extra security. And I will show you how to write INSTEAD OF triggers that make it all possible.

Back to Top
Accelerating Testing Using Data Virtualization
Tim Gorman , Delphix
When: Jun 26, 2017, Monday Session 3 , 2:00 pm - 3:00 pm
Room: Begonia
Topic: Database - Subtopic: Other Database

How much testing do you perform in your BI/DW environments? Do you even have a test environment? Do you test in production?

The biggest problem with testing in BI and DW environments is the size and velocity of data. Databases and applications have grown enormous and complex. "Storage is cheap" is simply not true. Need proof? Ask for 10 TB to provision a new test environment.

Provisioning a full environment for each developer or tester on each task of each project appears unrealistic, when each might require several terabytes or even petabytes of storage. And so everyone is limited to working in a small handful of shared environments that are refreshed only every few months, if ever, and both code quality and data quality suffer.

Data virtualization is the solution. Using thin-provisioning technologies, virtual databases and file systems only consume space from changed blocks, so it is possible to provision virtual terabytes for only a few actual megabytes. Coders and testers have full and independent read-write environments provided quickly in which to develop and test, improving code quality. Learn about the technical details behind this solution.

When I first heard about data virtualization, it sounded far-fetched, just a trick. Instead, it is the perfect solution to the perfect storm of more data quickly. Every IT shop will need to know how to provision test environments faster using less storage. It's not a matter of "if," but "when."

Back to Top
Barriers to Oracle Database in IaaS Cloud
Tim Gorman , Delphix
When: Jun 28, 2017, Wednesday Session 14 , 1:45 pm - 2:45 pm
Room: Begonia
Topic: Database - Subtopic: DevOps/Agile

IaaS cloud vendors, such as AWS, prefer that everyone migrate to the cloud, but what often happens is that non-production migrates for cost reasons but production stays on-premises. This phased path to the cloud can leave IT with a split personality: production on-premises on legacy proprietary UNIX platforms, non-production in the cloud on commodity Linux platforms.

Because the security risk on non-production systems is much higher than production, there is a requirement to mask personally identifiable information or confidential data before it is copied to non-production. Data virtualization employs thin cloning, snapshots, and network-attached data presentation, reducing cloning from hours or days to minutes. But there is more: your legacy UNIX (i.e. AIX, Solaris, HP-UX) databases aren't going anywhere off-premises because the cloud is based on Intel (i.e. Linux, Windows). So what to do?

In this session, learn how data virtualization and data masking make "split-brain IT" not just possible but desirable.

Back to Top
Top Five Cool Features in Oracle SQL Developer Data Modeler
Kent Graziano , Snowflake Computing
When: Jun 26, 2017, Monday Session 4 , 3:15 pm - 4:15 pm
Room: Verbena/Periwinkle
Topic: Database - Subtopic: DB Dev

Oracle SQL Developer Data Modeler is an industrial-strength data modeling tool that can be used for any data modeling task you need to tackle. Over the years, I have found quite a few features in the tool that I rely on to make me more efficient in developing my models. I will demonstrate at least five of these features, tips, and tricks including using the metadata export tool.

Back to Top
Analytic Views in Oracle Database 12.2: The Virtual Cube
Kim Berg Hansen , Trivadis Danmark A/S
When: Jun 27, 2017, Tuesday Session 6 , 8:30 am - 9:30 am
Room: Bluebonnet/Dogwood
Topic: Database - Subtopic: Other Database

Traditionally to model and analyze your data with dimensions and hierarchies, either you copy your data to a data warehouse and from there to a dimensional cube, or you have to write quite a lot of rather advanced code and SQL to emulate the same directly on your relational data.

With analytic views (introduced in Oracle Database version 12.2), you declaratively define the dimensions and hierarchies similar to creating a cube, but it is only stored as a metadata layer on top of your tables; it is a multidimensional *view* of your relational data. The SQL language has been expanded to allow a simpler query syntax on the analytic views to utilize these metadata and automatically use advanced analytic functions to give you dimensional analysis on real-time data. As SQL is used below the covers, performance can be tuned using query rewrite with materialized views or In-Memory options or any other option you would normally use for SQL tuning.

This session will show code examples covering a lot of the syntax you have for creating and using analytic views.

Back to Top
Hands-On Lab: Advanced SQL Topics - Analytic Functions
Kim Berg Hansen , Trivadis Danmark A/S
When: Jun 27, 2017, Hands on Lab Session 7, 11:15 am - 12:15 pm
Room: Goldenrod
Topic: Database - Subtopic: DB Dev

When analytic functions appeared in the database in version 8, they were the best thing to happen to SQL since the keyword SELECT was invented. Analytic functions are indispensable in a lot of use cases for creating highly efficient queries, often enabling you to avoid slow procedural code. Once you have started using analytic functions more than a couple of times, you'll develop the mindset for recognizing opportunities for utilizing them often in your daily work, making your applications highly efficient.

This hands-on lab will let you try out yourself a series of examples demonstrating the powerful aspects of analytic function syntax and various use cases, giving you practical experience that'll help you know when you profitably can use analytic functions in your work.

Pre-requisites for attendees:

You must bring your laptop - connected to the internet (wi-fi or otherwise)

You must have an Oracle Single-Sign-On Account, as the lab will be using http://livesql.oracle.com
(You'll probably already have such an account for OTN or MOS or other Oracle site, but if not, then it's free and you can create the account on-site, but you'll have more time for the lab if you have the account ready ahead of time).

Back to Top
Hands-On Lab: Advanced SQL Topics – Pattern Matching
Kim Berg Hansen , Trivadis Danmark A/S
When: Jun 28, 2017, Hands on Lab Session 14, 1:45 pm - 2:45 pm
Room: Goldenrod
Topic: Database - Subtopic: DB Dev

Often you need to work with how data interacts across rows, not just within a single row. Analytic functions can help a lot with this, but since version 12.1, row pattern matching has been an alternative that enables querying for patterns in the data in more complex ways than analytics can do - and at the same time in a simpler fashion as the syntax is very declarative. Once you are familiar with the syntax, you can use MATCH_RECOGNIZE for quite varied use cases, like searching patterns in stock ticker data, grouping sequences, bin fitting problems, and a lot more.

The syntax can be daunting at first glance, though, with a lot of options, so this hands-on lab lets you try out different ways of using the MATCH_RECOGNIZE clause showing the syntax with various use cases, letting you come to grips with how the various parts of the syntax work and interact with each other.

Prerequisites for attendees:
You must bring your laptop - connected to the internet (WiFi or otherwise)
You must have an Oracle Single Sign-On Account, as the lab will be using http://livesql.oracle.com
(You'll probably already have such an account for OTN or MOS or other Oracle site, but if not, then it's free and you can create the account onsite, but you'll have more time for the lab if you have the account ready ahead of time).

Back to Top
Six Reasons Why You Will Get Addicted to SQLcl Scripting
Sabine Heimsath , its-people GmbH
Co-presenter(s): Robert Marz, its-people GmbH
When: Jun 28, 2017, Wednesday Session 16 , 4:15 pm - 5:15 pm
Room: Verbena/Periwinkle
Topic: Database - Subtopic: DB Tools

SQLcl is ready to replace the reliable but somewhat outdated SQL*Plus as the new command line interface of the database. The most exciting new feature of SQLcl is scripting: Batch scripts can now be written in languages such as JavaScript, Python, or Perl. This means a veritable cornucopia of options, many of which are not obvious at first sight.

After a brief introduction to SQLcl, we will show many real-world examples that demonstrate the new possibilities. All examples are available for download to allow for further tests and exploration. This presentation provides many in-depth live demos.

Back to Top
Design Your Databases Using Oracle SQL Developer Data Modeler
Heli Helskyaho , Miracle Finland Oy
When: Jun 27, 2017, Tuesday Session 10 , 4:45 pm - 5:45 pm
Room: Verbena/Periwinkle
Topic: Database - Subtopic: Database Design

Oracle SQL Developer Data Modeler is one of the leading database design tools in the market. The amount of data is growing, and everybody is starting to understand the value of good-quality data for their business. The only way to have good-quality data and to understand your data is to design your databases. To be able to design them, you need a tool; paper and pen are not enough anymore. What is database designing, and how do you design databases using Oracle SQL Developer Data Modeler?

Back to Top
How to Design a Database? Let's Start with the Logical Model
Heli Helskyaho , Miracle Finland Oy
When: Jun 28, 2017, Wednesday Session 15 , 3:00 pm - 4:00 pm
Room: Verbena/Periwinkle
Topic: Database - Subtopic: Database Design

What is database designing, and how do you design a relational database? What is a logical design, and why do I need to create one? What is NF3 and BCNF? Why would I care about all the theory, and what is it, by the way? During this session, you will get answers to these questions plus about 100 more.

Back to Top
OMG! Identifying and Refactoring Common SQL Performance Anti-Patterns
Jeff Jacobs , Jeffrey Jacobs & Associates
When: Jun 28, 2017, Wednesday Session 16 , 4:15 pm - 5:15 pm
Room: Begonia
Topic: Database - Subtopic: DB Dev

Most presentations on SQL performance assume that the query developer is highly experienced in SQL and Oracle and focus on tracing and other techniques. Sadly, in today's world, knowledge of SQL and Oracle are not highly valued, and many SQL performance problems are the result of inexperience, misguidance, "heard it/read it somewhere," and various sources of misinformation. This presentation will address common "anti-patterns" in database design and SQL query writing that have been encountered over the years and how to fix them without tracing, changing init.ora parameters, or techniques requiring DBA-level privileges. It is focused on techniques that are typically available to developers. This presentation received a 2015 SELECT Journal Editor’s Choice Award.

Back to Top
Hands-On Lab: PDB Me, ASAP! Oracle Database 12cR2 Multitenant Workshop
Charles Kim , Viscosity North America
Co-presenter(s): Jim Czuprynski, ViON Corporation
When: Jun 26, 2017, Hands on Lab Sessions 1-2, 10:30 am - 12:45 pm
Room: Goldenrod
Topic: Database - Subtopic: DB Dev

Oracle Database 12cR2 has dramatically revamped the range of multitenant features, including faster PDB cloning with virtually no downtime, tighter resource control at the PDB level, ILM Automatic Data Optimization (ADO) policies for PDBs using Heat Maps, and even FLASHBACK recovery for individual PDBs. This two-hour workshop explores the latest features of 12cR2 multitenant and provides attendees with practical, hands-on experience as well as numerous code examples that they can immediately leverage when deploying, upgrading to, and migrating to CDBs and PDBs.

Back to Top
The THINGS Are Here! Using Oracle IoT Cloud Service
John King , King Training Resources
When: Jun 26, 2017, Monday Session 2 , 11:45 am - 12:45 pm
Room: Verbena/Periwinkle
Topic: Database - Subtopic: DB Dev

First, the internet connected us. Then we added computers and network connections to machines and things. Today, many “things” (computers, sensors, devices, appliances, cars, phones, etc.) are connected to the internet, to our applications, and to each other. The Internet of Things is exploding, and you need to be prepared for it. In this session, you will learn how the Internet of Things is changing our lives. Every day, more use cases appear where we harness the tremendous flow of data coming from “edge” devices to enable better business decisions. Oracle’s Internet Of Things Cloud Service is an instrumental part of this new world. This session will introduce you to IoT and Oracle’s Internet Of Things Cloud Service.

Back to Top
Give MAF a REST: Using REST/JSON Services in MAF
John King , King Training Resources
When: Jun 26, 2017, Monday Session 3 , 2:00 pm - 3:00 pm
Room: Azalea
Topic: Database - Subtopic: ADF and MAF

Oracle’s Mobile Application Framework (MAF) builds web applications quickly and easily that port to iOS and Android devices without target-specific customization. MAF applications may use data from Java POJO’s, the local SQLite database, SOAP/XML Web Services, REST/XML Web Services, and REST/JSON Web Services. This presentation shows attendees how to create MAF applications based upon REST/JSON Web Services. The combination of REST and JSON has become the standard mechanism for communicating with mobile applications; MAF developers attending this session will learn how to use them.

Back to Top
I've Looked at Cloud from Both Sides Now: Developer Cloud Service or Not?
Peter Koletzke , (in between)
When: Jun 26, 2017, Monday Session 5 , 4:45 pm - 5:45 pm
Room: Verbena/Periwinkle
Topic: Database - Subtopic: DevOps/Agile

If, like this presenter, you are a developer or IT professional who has been wary of cloud computing since first hearing about it, your objections to it probably run along the lines of price, complexity, loss of control over your development environment, security, and just good old stubbornness to change. Alternatively or additionally, if you work in an Oracle-oriented shop, the tendency may be to rely on Oracle's products, but your shop is waiting for Oracle's cloud products to mature before jumping in (flying up).

Whatever your opinion about cloud computing in general, and Oracle's competency in cloud products specifically, Oracle Developer Cloud Service is worthy of examination now. Oracle Developer Cloud Service is a Platform as a Service (PaaS) product that provides a complete development environment for creation of applications in any discipline (for example, APEX, ADF, JET, MAX, ABCS, or Forms).

On the "Up" side, this presentation explains this service and how you can use it as an out-of-the-box solution for the full life cycle of an application, or for integrating some of your own components into the service.

On the "Down" side, the presentation discusses why you may not want to use this service, and, if you do decide to use it, what to avoid when configuring and using the product.

The session closes with an example of setting up Oracle Developer Cloud Service to supply a full application life cycle that includes version control, code reviews, build integration, issue tracking, and deployment phases. You may be pleasantly surprised at what you learn about this product.

Back to Top
Thick Database is Alive: Leveraging the Oracle Database SQL and PL/SQL to Simplify Any User Interface Application Development
Peter Koletzke , (in between)
When: Jun 27, 2017, Tuesday Session 10 , 4:45 pm - 5:45 pm
Room: Bluebonnet/Dogwood
Topic: Database - Subtopic: DB Dev

Whether you develop applications for an Oracle database in APEX, ADF, MAF, JET, MAX, ABCS, or any other development framework or programming language, the development approach known as "thick database" can provide benefits in productivity, code reusability, and ease of application maintenance. This approach to development evolved from discussions in ODTUG channels over ten years ago.

The thick database approach consists of centralizing most application logic in the database, which greatly simplifies the user interface work. It also shields the application somewhat from UI technology changes, so if an application framework needs to be changed, the amount of code to rewrite is much less than with business logic in the application.

This presentation explains the benefits, principles of, and guidelines for using this approach. It discusses how business rules logic can be centralized and standardized so that application updates due to business changes are much easier. It also describes different levels at which you can use the thick database principles: extreme, modified, and conservative, and how to decide which level to use. It also explains how you would decide which business rules should be implemented in the user interface even if they are also written in the database.

The session also suggests a simple system you can create to track business rules as one part of thick database development as well as a starting point for creating test plans. The session then shows examples of the main SQL and PL/SQL code components you might use to implement thick database principles: table APIs, complex views with INSTEAD OF triggers, and business rules procedures.

Back to Top
A Real-World Comparison of the NoPlsql and Thick Database Paradigms
Toon Koppelaars , Oracle Corporation
Co-presenter(s): Bryn Llewellyn, Oracle Corporation
When: Jun 29, 2017, Deep-Dive Session, 9:00 am - 11:00 am
Room: Grand Oaks E/F
Topic: Database - Subtopic: DB Dev

This is a two-part session.

The NoPlsql paradigm starts with an object-oriented domain model in the middle tier. This leads naturally to treating the database as a bag of tables, so that primitive SQL statements express its API. The Thick Database paradigm starts with the design of the relational model. This leads naturally to allowing client-side code only to call PL/SQL subprograms, so that all SQL is done from PL/SQL. These two paradigms are mutually incompatible.

In the first part of our session, we show, based on real-world use cases, how the NoPlsql paradigm brings problems with correctness, security, and performance, and we note that projects that adopt the NoPlsql paradigm use most of their resources on developing plumbing code rather than code that implements actual business functionality. These problems are just the tip of the iceberg and we explain how the NoPlsql paradigm also brings maintenance nightmares.

In the second portion of the session, we turn to the Thick Database paradigm, rehearse the reasons for its superiority, and explain that it implies more than just allowing database calls to invoke only PL/SQL subprograms. We formalize a layered code classification scheme which leads to optimal understandability and maintainability of both your PL/SQL and your SQL code -- which properties bring the maximum probability of correct behavior. We will convince participants that adopting the Thick Database paradigm guarantees the avoidance of the awful problems brought by the NoPlsql paradigm and establishes the database tier as a reliable central service provider in the application landscape. We will debunk the myth that “moving business logic out of the data tier and into the middle tier” improves scalability.

Back to Top
Database Sunday Symposium Session 1
Bryn Llewellyn , Oracle Corporation
When: Jun 25, 2017, Sunday Symposium Database Session 1, 8:30 am - 10:30 am
Room: Cibolo Canyon 8/9/10
Topic: Database - Subtopic: Other Database

Session 1: 8:30 AM - 10:30 AM

Ten Rules for Doing a Pl/SQL Performance Experiment
Bryn Llewellyn, Oracle Corporation
I've all too often been asked to comment on a speed difference between two tests where each is presented to me as just a SQL*Plus spool file (prompts and all). Sometimes this is copied and pasted into the text of an email. Often, the text of the second spool file differs from the text of the first in just a couple of tiny details. Worst of all, each time is measured for just a single test run using SET TIMING ON. And the times are shown, like "Elapsed: 00:00:12.36", with indefensible precision. Sometimes the times are shorter. This is no way to conduct a performance experiment. This brief talk tells you how to do your experiment properly. I said "PL/SQL" in the title, 'cos that's what I'm known for. Really, I'm talking about any single-user test that runs entirely inside Oracle Database. I said "ten rules" 'cos a talk has to have a catchy title. Of course there's many more....

Why Test Cases Matter
Chris Saxon, Oracle Corporation
On AskTOM Chris and Connor are always asking for test cases. But are they really that necessary? An excellent test case. Drawing on questions from AskTOM Chris shows why they're important and discusses what you need to do to create an excellent test case.

Lifecycle Management and Continuous Integration for Database Code
Shay Shmeltzer, Oracle Corporation
In this session we'll show you how to effectively manage database code changes and how to automate the database development life cycle. We'll cover tracking requirements; versioning and modifying code; conducting code reviews; testing and deploying the changes across systems - all with the help of Oracle Developer Cloud Service, which is included in your Oracle Database Cloud license.

Back to Top
A Holistic Approach to Database Security
Robert Lockard , Oraclewizard
When: Jun 26, 2017, Monday Session 4 , 3:15 pm - 4:15 pm
Room: Begonia
Topic: Database - Subtopic: DBA

For years we have been locking down the software to protect information. This presentation puts the focus where it belongs: identifying, protecting, and selecting the correct tools to protect your data.
Starting with a brief history of security breaches and the impact to both companies and consumers, the presenter will move through a methodology of identifying sensitive information, creating a risk matrix, and which tools are available to mitigate information leaks.

Back to Top
Thinking Clearly About Testing Performance
Cary Millsap , Cintra Software and Services
When: Jun 26, 2017, Monday Session 4 , 3:15 pm - 4:15 pm
Room: Bluebonnet/Dogwood
Topic: Database - Subtopic: Database Testing

Testing for functional correctness is generally a matter of specifying the right output for a given input and then using a tool that check whether your code produced the output you specified. Testing performance, though, is a lot harder, even conceptually. You can use a tool to check whether a given function "runs in D seconds or less," but there's more to it than that, because realistic data volumes and loads matter so much. But you can prevent a lot of post-production performance problems without having to spend a gazillion dollars on "perfect" performance testing. In this session I'll help you learn how.

Back to Top
Introduction to ADF: Building an Application in 60 Minutes
Jamie Morrison , Peak Indicators Ltd.
When: Jun 27, 2017, Tuesday Session 7 , 11:15 am - 12:15 pm
Room: Azalea
Topic: Database - Subtopic: ADF and MAF

Discover how to create a basic browser based application using the latest version of JDeveloper 12c and Application Development Framework (ADF).

In the session we will start with a blank canvas from which we will build up a working HR application using core technologies and functionality, we will compile it, then deploy it to our Weblogic server where we can see it in action. During the session we will dip into aspects such as creating data capture forms, skinning, and creating custom menu options.

Back to Top
Tips and Best Practices for DBAs
When: Jun 26, 2017, Monday Session 5 , 4:45 pm - 5:45 pm
Room: Azalea
Topic: Database - Subtopic: DBA

A vibrant session with “real tips” for real-world daily database problems a DBA could find. Here you will learn how to improve your productivity, how to solve some real DBA problems, and also learn several tips to help you to become a successful DBA. This session is based on some of the most frequent questions I’m asked on my blog and during my presentations. (Version 3 of this presentation.)

Back to Top
Logging or Nologging: That is the Question!
When: Jun 27, 2017, Tuesday Session 7 , 11:15 am - 12:15 pm
Room: Begonia
Topic: Database - Subtopic: DBA

The main question about NOLOGGING I hear all the time is: does creating a table with the NOLOGGING option means there is “no generation of redo ever," or just that the initial creation operation has no redo generation, but that DML down the road generates redo? How and when can the NOLOGGING option be employed?
Redo generation is a vital part of the Oracle recovery mechanism. Without it, an instance will not recover when it crashes and will not start in a consistent state. Excessive redo generation is the result of excessive work on the database. This presentation covers the subject of reducing redo generation using LOGGING and NOLOGGING options, the differences between them, how it happens, how to reduce it, and when to use. Also, you will find examples and tips regarding each one of them.

Back to Top
The Best 12c R1 & R2 Query Tuning New Features
Rich Niemiec , Viscosity North America
When: Jun 26, 2017, Monday Session 1 , 10:30 am - 11:30 am
Room: Bluebonnet/Dogwood
Topic: Database - Subtopic: DB Dev

This presentation will look at which 12c new features should be investigated for query tuning. Most of the features that will be covered will be related to the developer & DBA. There will be simple examples to show the basic functionality of the new features:

- Using invisible columns
- Multiple indexes on the same column
- Adaptive execution plans
- Runaway query management
- Online move partition
- Partial indexes for partitioned table
- Enhanced DDL online
- Other 12c query tuning new features
- Using Oracle In-Memory database

Back to Top
Creating Your First Database to Access with Oracle's DBaaS (Database as a Service)
Rich Niemiec , Viscosity North America
When: Jun 27, 2017, Tuesday Session 9, 3:30 pm - 4:30 pm
Room: Begonia
Topic: Database - Subtopic: DBA

This presentation will show the steps to create a database in the Oracle Cloud using Oracle's Database Cloud Service or DBaaS (DataBase as a Service). It will give the brief steps as well as showing how to use the free test service. We'll also see different methods for testing in the cloud as well as the different uses for the cloud initially and eventually.

Back to Top
Oracle 12c for Developers
Alex Nuijten , allAPEX
When: Jun 26, 2017, Monday Session 3 , 2:00 pm - 3:00 pm
Room: Bluebonnet/Dogwood
Topic: Database - Subtopic: DB Dev

Do you want to get up to speed with the most current release of the Oracle Database? Then this session is for you. You will learn the most exciting and most useful new features from the Oracle Database 12c which can make your work as database developer a lot easier. There is more to the Oracle Database 12c than just pluggable databases.

Back to Top
Controlling Execution Plans - Workshop
Kerry Osborne , Accenture Enkitec Group
When: Jun 28, 2017, Wednesday Session 14 , 1:45 pm - 2:45 pm
Room: Bluebonnet/Dogwood
Topic: Database - Subtopic: Other Database

This presentation will be an online hacking session. The intention is to log on to a system and run through several scenarios utilizing a set of scripts developed to quickly implement SQL Patches, SQL Profiles, and SQL Baselines for controlling execution plans or applying specific hints to the SQL behind the scenes for other purposes. The workshop will also demonstrate scripts for modifying SQL Text on the fly using the new 12c feature, SQL Translation Framework.

Note: The scripts will be provided as part of the presentation materials.

Back to Top
Full Table Scan: Friend or Foe?
Mauro Pagano , Accenture Enkitec Group
When: Jun 27, 2017, Tuesday Session 9, 3:30 pm - 4:30 pm
Room: Bluebonnet/Dogwood
Topic: Database - Subtopic: DB Dev

"Full table scan is bad evil." How many times have you heard this claim? It's one of those myths in the Oracle performance world that never goes away.
It's only a myth and it's just plain wrong! Especially now with all the advancements in the software and not just Oracle.
How many times did you spend hours trying to avoid a full scan, just to find out performance wasn't that great once you get an index used?
This session focuses on why full scan has been demonized in the past, why this claim is false, why Oracle is smart enough to choose a full table scan when it's worth, and how to make sure that once Oracle chooses it, the full scans runs at its best.

Back to Top
Adapting to Adaptive Plans on 12c
Mauro Pagano , Accenture Enkitec Group
When: Jun 28, 2017, Wednesday Session 13, 11:15 am - 12:15 pm
Room: Bluebonnet/Dogwood
Topic: Database - Subtopic: DB Dev

Did you notice that many navigation apps can suggest, in real time, to deviate from the initial route because of traffic or accidents?
It's pretty cool right? You wanted to take 5th, but there is an accident so your initial plan doesn't look so good anymore once you hit the road.
Oracle 12c can do the same, the optimizer can generate an execution plan (your route) keeping the door open for changes in case more data than expected is being processed (traffic / accident).
This is a great feature but it requires a little shift in the way we think about performance; we need to be more open to changes just like our navigation app.
This session focuses on how this feature works, what it means for us, when it can help us, and most important how to look at execution plans that can change after they started their execution.

Back to Top
Oracle Database Automation: From Snowflake Instances to DBaaS
Simon Pane , Pythian
When: Jun 26, 2017, Monday Session 5 , 4:45 pm - 5:45 pm
Room: Begonia
Topic: Database - Subtopic: DevOps/Agile

Ever wonder why you can spin-up an Oracle Database environment from a public cloud provider in mere minutes yet it takes days to provision and configure one internally?

Oracle Database provisioning and management using DevOps style processes may seem like mixing oil and water, but it doesn't have to be that way. In fact, it's very possible without any additional at-cost tools. The resulting automation leads to "efficiency," "standardization," and "consistency" - pillars of scalability for effectively managing large database environments.

This presentation reviews how organizations can implement database deployment and management automation as an underpinning technology for a DBaaS using common DevOps tools such as Ansible to: prepare servers, deploy Oracle software, create databases, implement DR configurations, and customize databases with site specific requirements in a highly automated manner, regardless of whether the host servers are physically on-premise or in the public cloud.

The results are databases that are easier to manage, as well as a greatly reduced service time for database provisioning requests. Literally taking the implementation time down from days to less than one hour end-to-end!

Back to Top
Modernizing Your DBA Scripts with the Oracle Scheduler
Simon Pane , Pythian
When: Jun 28, 2017, Wednesday Session 12 , 9:45 am - 10:45 am
Room: Begonia
Topic: Database - Subtopic: DBA

As the Oracle Database evolves, so should the way DBAs monitor and manage it. And even though the Oracle Database Scheduler was introduced over a dozen years ago with Oracle 10g, almost all DBA environments still rely heavily on the Linux (UNIX) CRON for scheduling of database monitoring, management, or backup jobs.

But the Oracle Database Scheduler isn't just for developers and application logic. Instead, it should also be the primary scheduling tool for DBAs and DBA scripts; regardless of whether those scripts are SQL based, Linux shell scripts, or Windows command (batch) files.

This presentation convinces DBAs why the Oracle Database Scheduler should be their tool of choice by covering the profound functional and security benefits of using the Oracle Database Scheduler over OS scheduling tools. How to use and manage the Oracle Scheduler effectively, including concrete examples on how to use it with Linux (UNIX) shell scripts and Windows command files is detailed. Finally, exciting new 12c Scheduler enhancements are discussed and demonstrated.

So whether it's for monitoring jobs, management/maintenance jobs, or even a database backup jobs (RMAN or otherwise), it really is "time to schedule with the scheduler" and get rid of all of those old-school CRONs.

Back to Top
Virtualization – To Infinity and Beyond!
When: Jun 27, 2017, Tuesday Session 8 , 2:00 pm - 3:00 pm
Room: Begonia
Topic: Database - Subtopic: DBA

Cloud is everywhere and the database administrator is caught in the middle. How do you know where to start and what to migrate first? How do you perform consolidation planning and ensure data security?

This session builds on the impressive customer experience from Kellyn Pot’Vin-Gorman with years of architecting virtualized environments to show how to simply and securely migrate to the cloud. A full demonstration, along with tips and tricks to show how the DBA can secure their environment to allow a self-service option so they no longer are the roadblock to projects!

Back to Top
Oracle & Apache Kafka: Stories from the Message Bus Stop
Bjoern Rost , Pythian
When: Jun 27, 2017, Tuesday Session 10 , 4:45 pm - 5:45 pm
Room: Begonia
Topic: Database - Subtopic: DB Tools

Apache Kafka is a massively scalable message queue that is being used at more and more places connecting more and more data sources. This presentation will introduce Kafka from the perspective of a mere mortal Oracle DBA and share the experience of (and challenges with) getting events from the database to Kafka and possibly even back-using different solutions and connectors.

Back to Top
DevOpsify DBA Tasks
Bjoern Rost , Pythian
When: Jun 28, 2017, Wednesday Session 12 , 9:45 am - 10:45 am
Room: Verbena/Periwinkle
Topic: Database - Subtopic: DevOps/Agile

Organizations are struggling to manage and standardize an ever-increasing number of database deployments. This presentation shows how scripting and automation tools can be used to provision databases and to manage resources like users, tablespaces, instance parameters, and settings in general. With this setup one can manage a large range of systems from a very small set of descriptive text based configuration files. More so, these configs are easily managed in a revision control system like git enabling agile workflows for database change management.

Back to Top
Take a Walk on the Wild Side – A Beginner's Guide to Regular Expressions in Oracle
Helen Sanders , Temple University
Co-presenter(s): Justin Biard, Focal Trend, Inc.
When: Jun 28, 2017, Wednesday Session 11, 8:30 am - 9:30 am
Room: Azalea
Topic: Database - Subtopic: DB Dev

Don't let regular expressions scare you! They'll make your life easier once you get the hang of them! We'll give the lowdown on where they came from and how to use them. This session is especially for the novice/beginner, and is meant to be an introduction to regular expressions.

Back to Top
Database Sunday Symposium Session 4
Chris Saxon , Oracle Corporation
When: Jun 25, 2017, Sunday Symposium Database Session 4, 3:15 pm - 5:00 pm
Room: Cibolo Canyon 8/9/10
Topic: Database - Subtopic: Other Database

Session 4: 3:15 PM - 5:00 PM

The "Hot Patching" Myth–Or Why You Have No Choice but to Use EBR for Zero-Downtime Patching
Bryn Llewellyn, Oracle Corporation
My scope is doing patching among the set of artifacts inside an Oracle Database that implement an application's back end. A myth has arisen that certain changes can be made safely with "create or replace" while the application is still available for normal, highly concurrent use. Managers seem to be especially attached to this myth. I'll go through a couple of examples that seem, on intellectual analysis by the uninitiated, to be safe. And I'll show you, with naively designed tests, that the "no danger" hypothesis isn't disproved. Of course, these are simulated multi-user tests. But then, by tweaking some timing knobs, I'll bring the hidden danger out into the open. It's all about relatively unlikely race conditions that, nevertheless, are bound, sooner or later, to occur in a busy production system. Then I'll explain that, should Oracle Database implement a much more pessimistic locking strategy, the race condition errors could be prevented. But if we did that, you'd hate us 'cos everything would slow down. I'll remind you that Oracle Database, therefore, is designed to perform very well in the optimistic, common-sense, scenario: that you "just say no" to doing DDLs on an application's within-database artifacts while it's available for normal highly concurrent use. I'll conclude by reminding you that EBR isn't a luxury. Rather you have a simple stark choice: always take downtime for all patching; or adopt and use EBR to allow safe zero-downtime patching.

Hacking into Oracle Database
Chris Saxon, Oracle Corporation
The Danger of SQL Injection: Chris will show how easy it is to access "private" data in applications vulnerable to SQL injection. He'll then go on to discuss steps you should take to keep your data safe.

New Open Source Projects from Database Tools
Barry McGillin, Oracle Corporation
Barry will share what projects are being presented on open source on Github and how you can use them or contribute to them. In particular, we’ll show the upcoming REST based JDBC driver and how REST enabling does not mean rewriting your application.

30-Minute Q&A Panel - Questions/discussion points to be submitted in advance.
Everyone is encouraged to participate. Panel will be moderated by Helen Sanders.

Back to Top
12 Things Developers Will Love About Oracle Database 12c Release 2
Chris Saxon , Oracle Corporation
When: Jun 26, 2017, Monday Session 5 , 4:45 pm - 5:45 pm
Room: Bluebonnet/Dogwood
Topic: Database - Subtopic: DB Dev

Oracle Database 12c Release 2 is here!

The headline features are Sharding, Multitenant and Application Containers. But it's the improvements to SQL that make a real difference in your day-to-day life work with Oracle Database.

In this session Chris gives you an overview of the changes to SQL and PL/SQL that will help you build faster, more robust database applications.

If you're a developer or DBA who regularly writes SQL or PL/SQL and wants to keep up to date this session is for you!

Back to Top
SQL Magic!
Chris Saxon , Oracle Corporation
When: Jun 28, 2017, Wednesday Session 11, 8:30 am - 9:30 am
Room: Verbena/Periwinkle
Topic: Database - Subtopic: DB Dev

In this fun session you’ll see SQL used in new and exciting ways. Chris will perform SQL "magic tricks" including:

- Sawing the Query in Half: starting with a normal query, Chris will split it into smaller and smaller chunks that somehow all give the same result!
- Find the Card: after getting an audience member to choose a "card" (row) from a "deck" (table), Chris will find it by making it float to the top of the table.
- The Magically Changing Data Type: watch as a number changes to a date and back again!

But unlike real magicians, he'll show you how the tricks work. This will enable you to perform your own "SQL magic” and build better Oracle database applications.

This session is for developers and DBAs looking to expand their SQL skills. It highlights features that are new to 12c as well as little used existing options.

Back to Top
America’s Next Top Model-er Feature
David Schleis , Insum Solutions
When: Jun 27, 2017, Tuesday Session 7 , 11:15 am - 12:15 pm
Room: Verbena/Periwinkle
Topic: Database - Subtopic: DB Tools

Oracle SQL Developer Data Modeler (SDDM) is a remarkably useful tool, but despite all of the books, blogs, and presentations some of its most powerful functionality goes unused. Scripting within SDDM allows you to make modifications to your model, make sure that your models conform to your standards, and also create customized reports that can be used for import into other tools such as Jira.

This session is an introduction to the powerful scripting capabilities found in SDDM, and contains numerous examples of scripts and the SQLgr library that will help you capitalize on the wealth of information captured within your models.

Back to Top
Hands-On Lab: Feelin’ Groovy – Scripting with SQLgr
David Schleis , Insum Solutions
When: Jun 27, 2017, Hands on Lab Sessions 9-10, 3:30 pm - 5:45 pm
Room: Goldenrod
Topic: Database - Subtopic: DB Tools

SQL Developer Data Modeler (SDDM) and SQLcl both provide the ability to enhance their power through scripting. While the default scripting language is JavaScript, fortunately Groovy can also be used. Groovy is an incredibly powerful and versatile scripting language already a part of a number of Oracle tools. Groovy is easier to learn than JavaScript and allows you to do more with less code.

This presentation is an introduction to the Groovy language and the SQLgr libraries. Focus will be placed on Groovy features specifically in regards to their use in the scripting of SQLcl and SDDM. Knowledge of these features, along with the SQLgr libraries, will allow attendees to begin building their own scripts immediately when then they get back to work.
Prerequisites: check out this blog post about installing the VM: http://www.thatjeffsmith.com/archive/2014/02/introducing-the-otn-developer-day-database-12c-virtualbox-image/

Back to Top
Developing JavaScript Applications: The Oracle Offering
Shay Shmeltzer , Oracle Corporation
When: Jun 26, 2017, Monday Session 1 , 10:30 am - 11:30 am
Room: Verbena/Periwinkle
Topic: Database - Subtopic: DB Tools

JavaScript might be the most used development language out there today. In this session, we'll review Oracle's tools and framework for developing applications with JavaScript. We'll talk about the complete ecosystem Oracle has built around JavaScript discussing and demo-ing Oracle JET, Oracle Application Builder Cloud Service, Oracle Developer Cloud Service, and more. Learn about the architecture and the relationships between the various products and when they'll be useful for you.

Back to Top
Developing On-Device Mobile Apps – A Visual Approach
Shay Shmeltzer , Oracle Corporation
When: Jun 28, 2017, Wednesday Session 15 , 3:00 pm - 4:00 pm
Room: Azalea
Topic: Database - Subtopic: ADF and MAF

Learn how to create device resident applications without writing a single line of code in a visual way. See how Oracle Application Builder Cloud Service enables you to accelerate development of applications with an intuitive browser based development approach. Start from scratch - create your DB objects and build your UI in minutes.

Back to Top
SQL Tuning Workshop Part 1
Carlos Sierra , Oracle Corporation
Co-presenter(s): Mauro Pagano, Accenture Enkitec Group
When: Jun 26, 2017, Database 10:30 - 12:30, 10:30 am - 12:30 pm
Room: Indian Paintbrush
Topic: Database - Subtopic: Other Database

SQL Tuning is a science. SQL Tuning is an art. You may have heard both claims. SQL Tuning can indeed be a complex task requiring the use of some attributes of both brain hemispheres: analytical thinking and creativity. If we want to enhance our SQL Tuning skills we may need then to take them both into consideration.

This four-hour training session includes two aspects of SQL Tuning. It provides practical knowledge by diving into the "4 T's" of SQL Tuning: techniques, tips, tricks, and tools; and it arouses our troubleshooting skills by using some case studies, guiding participants towards possible solutions. Analytical and creative thinking are both taken into consideration and practiced within a friendly environment where there is no such thing as a dumb question.

The targeted audience for this "Practical SQL Tuning" session is both developers and DBAs, with a desire to increase their SQL Tuning skills within a dynamic and participate-rich environment. Open questions are welcomed; sharing knowledge and experience is encouraged and expected. Topics of interest are selected by participants at the beginning of the workshop, then immediately voted on. Content sequence of this workshop is driven by weight of topics voted on.

Class is limited to the first 48 participants. Role will be taken in part 1 and preference will be given to part 1 participants for entrance into part 2.

Back to Top
SQL Tuning Workshop Part 2
Carlos Sierra , Oracle Corporation
Co-presenter(s): Mauro Pagano, Accenture Enkitec Group
When: Jun 26, 2017, Database 3:30- 5:30 , 3:30 pm - 5:30 pm
Room: Indian Paintbrush
Topic: Database - Subtopic: Other Database

SQL Tuning is a science. SQL Tuning is an art. You may have heard both claims. SQL Tuning can indeed be a complex task requiring the use of some attributes of both brain hemispheres: analytical thinking and creativity. If we want to enhance our SQL Tuning skills we may need then to take them both into consideration.

This four-hour training session includes two aspects of SQL Tuning. It provides practical knowledge by diving into the "4 T's" of SQL Tuning: techniques, tips, tricks, and tools; and it arouses our troubleshooting skills by using some case studies, guiding participants towards possible solutions. Analytical and creative thinking are both taken into consideration and practiced within a friendly environment where there is no such thing as a dumb question.

The targeted audience for this "Practical SQL Tuning" session is both developers and DBAs, with a desire to increase their SQL Tuning skills within a dynamic and participate-rich environment. Open questions are welcomed; sharing knowledge and experience is encouraged and expected. Topics of interest are selected by participants at the beginning of the workshop, then immediately voted on. Content sequence of this workshop is driven by weight of topics voted on.

Class is limited to the first 48 participants. Role will be taken in part 1 and preference will be given to part 1 participants for entrance into part 2.

Back to Top
Understanding SQL Trace, TKPROF, and Execution Plan for Beginners
Carlos Sierra , Oracle Corporation
When: Jun 27, 2017, Tuesday Session 8 , 2:00 pm - 3:00 pm
Room: Verbena/Periwinkle
Topic: Database - Subtopic: DB Tools

In this session, participants will learn about producing a SQL Trace then a summary TKPROF report. A sample TKPROF is navigated with the audience, where the trivial and the not so trivial is exposed and explained. Execution Plans are also navigated and explained, so participants can later untangle complex execution plans and start diagnosing SQL performing badly.

Back to Top
SQL Tuning 101
Carlos Sierra , Oracle Corporation
When: Jun 28, 2017, Wednesday Session 15 , 3:00 pm - 4:00 pm
Room: Bluebonnet/Dogwood
Topic: Database - Subtopic: DB Dev

SQL Tuning is a complex and intimidating area of knowledge, and it requires years of frequent practice to master it. Nevertheless, there are some concepts and practices that are fundamental to succeed. From basic understanding of the Cost-Based Optimizer (CBO) and the execution plans, to more advanced topics such as plan stability and the caveats of using SQL Profiles and SQL Plan Baselines, this session is full of advice and experience sharing. Learn what works and what doesn't when it comes to SQL Tuning.

Back to Top
Database Sunday Symposium Session 2
Jeff Smith , Oracle Corporation
When: Jun 25, 2017, Sunday Symposium Database Session 2, 11:00 am - 12:00 pm
Room: Cibolo Canyon 8/9/10
Topic: Database - Subtopic: Other Database

Session 2: 11:00 AM - 12:00 PM

100 SQL Developer Tricks in 20 Minutes
Jeff Smith, Oracle Corporation
Jeff will share as many developer tricks as he can in 20 minutes.

Leveraging Hyperlinks in REST APIs
Colm Divilly, Oracle Corporation
Colm will describe why hyperlinks are essential to good REST APIs, how to generate them using Oracle REST Data Services and cover tips and best practices for hyperlinks.

Oracle Optimizer Isn’t Black Magic
Maria Colgan, Oracle Corporation
It has long been felt that the internals of the Oracle Optimizer were shrouded in mystery and that a degree in wizardry is required to be able to make it do the right thing. This session aims to dispel this myth once and for all by showing exactly how the Optimizer comes up with its cardinality estimates.

Back to Top
SQLcl & SQL Developer Tips & Tricks
Jeff Smith , Oracle Corporation
When: Jun 27, 2017, Tuesday Session 9, 3:30 pm - 4:30 pm
Room: Verbena/Periwinkle
Topic: Database - Subtopic: DB Tools

Fewer keystrokes, fewer clicks = more code, more productivity, more fun.

This session concentrates on the power features that most users bypass when using Oracle SQL Developer and our new command line interface, SQLcl. Do you use all of the shortcuts available to you? After this talk, you'll know how to get what you want, as quickly as you want.

We're rebuilding this session from scratch. That's right, in 2017, this talk will be BRAND NEW. So if it's been awhile since you've seen it, come back and get caught up.

As always, our goal is for each attendee to pick up one to three techniques that will drastically impact their productivity and save them time when working with Oracle Database.

Back to Top
SQL Developer: Three Features You're Not Using but Should Be
Jeff Smith , Oracle Corporation
When: Jun 28, 2017, Wednesday Session 13, 11:15 am - 12:15 pm
Room: Verbena/Periwinkle
Topic: Database - Subtopic: DB Tools

You write SQL, get results.

You click around objects, get data to Excel.

You write PL/SQL, compile it and view your errors.

That describes what 80% of our users do in Oracle SQL Developer. This session will expose 3 features that will turbo-charge your experience with SQL Developer and the Database. This session aims to make you more productive and valuable to your Oracle Database development organization.

Learn how to take those 600 files you currently have all of your hand crafted SQL in and turn them into interactive reports.

Learn how to find stuff in your database by taking advantage of PL/Scope and our search feature.

Learn how to build your own screens - that's right, learn how to use a bit of basic XML and SQL to extend SQL Developer to do what you want it to do.

Back to Top
Hands-On Lab: Using the Cloud (or Oracle VirtualBox) to Build a DBA Practice Environment
Richard Soule , C2 Consulting, Inc.
When: Jun 28, 2017, Hands on Lab Sessions 11-12 , 8:30 am - 10:45 am
Room: Goldenrod
Topic: Database - Subtopic: DBA

For those who really want to learn the how and why of building an Oracle Database system from scratch, this is your session! Bring your own laptop, or use one of our hosted servers and we’ll walk through the complete installation and configuration of an Oracle Linux desktop, Oracle Grid Infrastructure with Oracle Restart and ASM including ACFS, Oracle Database 12c Multitenant, Oracle APEX, SQL/Developer and SQLcl, and more. Best practices from building databases for real world deployments as well as from teaching Oracle Database certification classes will be included throughout the session.
(Ideally bring a laptop with a lot of memory and available disk space and download and install VirtualBox to your machine.)

Back to Top
Do More with Data Pump: Tips and Techniques
Biju Thomas , OneNeck IT Solutions
When: Jun 27, 2017, Tuesday Session 6 , 8:30 am - 9:30 am
Room: Verbena/Periwinkle
Topic: Database - Subtopic: DBA

Datapump was introduced in Oracle Database 10g, and has evolved over the versions with various features and performance improvements to migrate data and objects. The legacy export (exp) / import (imp) utility is still maintained in all versions of database including 12c for backward compatibility, and to migrate legacy data to newer versions of database. In this session the speaker shows you how to extend datapump for your various data and object migration needs outside of copying a table or schema. You will learn to export public and private database link and synonyms, various object filtering and row filtering techniques, improving performance of data pump operations, migrate data without using any space for dump file, changing storage properties during export and import, and methods to verify the contents of export dump file.

Back to Top
Digital Transformation: Strategy for Moving from Legacy to Enterprise Mobility
Mia Urman , AuraPlayer
When: Jun 28, 2017, Wednesday Session 13, 11:15 am - 12:15 pm
Room: Azalea
Topic: Database - Subtopic: ADF and MAF

As mobile becomes the primary means for accessing information, enterprises must find a way to accelerate mobilization. The Oracle Mobile Cloud is the missing ingredient to create mobile apps at the speed of your business and empower the front lines of your business with back office data. Oracle Mobile Cloud Service provides built-ins for push notifications, object storage, user management, analytics, and an API designer and catalog. But what should you do if your business is stuck with a mountain of Oracle Forms or EBS? How can you leverage your existing business logic while transforming the user experience to the digital world? In this session we will discuss how to begin your mobile journey; Including real life examples of customers who have been successful at it! This session will also include demos of how Oracle Mobile Cloud Service makes it possible for customers to mobile-enable their legacy systems.

Back to Top
Leveraging Oracle Database In-Memory to Accelerate Business Analytic Applications
Kai Yu , Dell EMC
When: Jun 26, 2017, Monday Session 2 , 11:45 am - 12:45 pm
Room: Begonia
Topic: Database - Subtopic: DBA

By introducing In-Memory column store, Oracle Database In-Memory (DBIM) significantly improves the performance for analytic queries as well as mixed workloads. Come to this session to learn Oracle Database In-Memory under the hood: the dual format memory architecture and configuration, how the data is populated into In-Memory column store and it helps query performance. This presentation also covers further enhancements of DBIM in Oracle Database 12cR2: Join group, and In-Memory expression, In-Memory active Data Guard support, etc. Through some case studies of business analytics projects, this presentation covers the practices of leveraging DBIM to improve the query performance of business analytic applications and how to use In-Memory adviser to determine the objects that need to be loaded into In memory column storage. We also will present some analysis on the performance gains by using IM memory features and when and how these gains can be achieved.

Back to Top