UTOUG Training Days 2018 has ended

Create Your Own Event

UTOUG Training Days 2018

9:45am MDT

Leveraging Partitioned External Tables: Primer and Practical Examples

Oracle Database 12c is the first release to offer the capability to access a file in HDFS or HIVE format as an external table. Through live and recorded demonstrations, this session will explain how an Oracle DBA can leverage these new features to gather data in tabular format from these file formats while leveraging the best tool ever designed to filter, sort, aggregate, and report information: Structured Query Language. Through presentations and online demonstrations, this session will:
• Review the growing need to access big data in different file formats stored in NoSQL databases and data lakes.
• Illustrate how to leverage Oracle Big Data SQL to access and process data in other formats.
• Provide practical boundaries for leveraging these techniques to access data in various external formats

Agenda:
1. Big Data and IoT: Beyond Simplistic Rows and Columns
2. A Sharper Knife You Already Own: The Case for SQL vs. NoSQL
3. New EXTERNAL Table Drivers: ORACLE_HDFS and ORACLE_HIVE
4. Leveraging Partitioning and Parallelism with EXTERNAL Tables
5. Practical Examples of Leveraging Big Data Access Drivers
6. Now, a Warning: Limitations of Big Data SQL and Its New Drivers

Speakers

James Czuprynski

Chief StoryTeller, Zero Defect Computing, Inc.

Jim Czuprynski has 40+ years of professional experience in Information Technology, serving diverse roles at various Fortune 1000 companies before becoming an Oracle DBA in 2001. He has been an Oracle ACE Director since 2014 and is a sought-after public speaker on Oracle technology... Read More →

Wednesday March 21, 2018 9:45am - 10:45am MDT
0110, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

9:45am MDT

Oracle Database 12.2 Application Containers

The single most important new feature in Database 12.2 is the new application containers that come with the multitenant option. The container database architecture and multitenancy were introduced into the Oracle database in version 12.1 and the capabilities have been vastly expanded in release 12.2, combining brilliant new technology with a solid business case.
This session by ACE Director Alumnus Daniel Morgan will present both the concept and the reality with a demonstration, live in SQL*Plus, of the entire process, and all of the code, required to implement a container database with application containers.

Speakers

Daniel Morgan

Oracle ACE Alumni, Meta7

Oracle ACE Director Daniel Morgan has more than 25 years' experience working with Oracle products. Dan wrote the Oracle curriculum for the University of Washington, was the program's primary instructor for 10 years, is the Morgan behind the MorgansLibrary.org website, and is currently... Read More →

OracleDatabase12.2utoug18 app cont pdf

Wednesday March 21, 2018 9:45am - 10:45am MDT
3180, 3rd Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

11:15am MDT

One Ring to Rule Them All: Consolidating Messaging into Slack

Discover how Bodybuilding.com simplified the lives for its on-call teams, lessened the burden on senior staff, shortened issue resolution times, and discovered a new way to share diagnostic information using Slack, a cloud-based team messaging and collaboration tool. Slack opens up new ways to manage, monitor, and control database environments.
We'll discuss future plans, including Slack-driven automation and natural language queries that will distribute or eliminate many low-level tasks and tactical work, freeing DBAs to focus on more important efforts.
Learning Objectives:
• Learn how we used Slack to unify messaging and notifications into a single interface, providing greater control over how, what, when, and why we're informed of events.
• Discover how Bodybuilding.com leveraged Slack to solve common complaints by on-call teams—alert fatigue, false alarms, being tied to a laptop or VPN, compartmentalization, and low or limited visibility of issues.
• See how to use the Slack API to interact with a database to allow remote management, automation, and natural language query and control by end users.

Speakers

Sean Scott

Managing Principal Consultant, Viscosity North America

Sean Scott is an Oracle ACE Director, Data on Kubernetes Community Ambassador, Oracle Certified Professional, a featured speaker at user group conferences and events worldwide, and the author of "Oracle on Docker: Running Oracle Databases in Linux Containers." He works at the intersection... Read More →

UTOUG Slack key

Wednesday March 21, 2018 11:15am - 12:15pm MDT
0160, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

11:15am MDT

What's New in Oracle Database 18c

The cloud changes everything, and Oracle Database recently switched to a new annual release model, with Oracle Database 18c as the first release in this new model. This session is a unique opportunity to get ahead of the curve and learn what's new in Oracle Database 18c directly from the Oracle Database development team.

Speakers

Maria Colgan

Master Product Manager, Oracle Corporation

Maria Colgan is a master product manager at Oracle Corporation and has been with the company since version 7.3 was released in 1996. Maria's core responsibility is creating material and lectures on the Oracle Database and the best practices for incorporating it into your environments... Read More →

What to expect from Oracle Database 18c pdf

Wednesday March 21, 2018 11:15am - 12:15pm MDT
0180, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

1:15pm MDT

How to Keep Your Database Running Using Oracle's Automatic Diagnostic Repository (ADR)

Learn how to be a proactive DBA and keep your databases running by using Oracle's new tool, Automatic Diagnostic Repository (ADR). This presentation will help database administrators provide their customers with a way to reduce the cost of ownership by reducing the time to troubleshoot anomalies. It will also help administrators gather information to see what is potentially causing problems, which will bring about higher availability. When you get back home, you will be able to use this tool to provide and improve the reliability and availability of your system.
This presentation will cover:

What is ADR and what does it do?
What are some of the commands?
How do I use it? Step-by-step example of troubleshooting a problem.
How this tool can package incidents and problems information for uploading to Oracle support.
Q&A

Speakers

Michael Nelson

Collaborate Conference Committe DBA, Northrop Grumman

Michael is a BS-degreed computer science professional with an MBA and 20 years' experience as senior database administrator with Northrop Grumman. He is experienced in managing object relational database (Oracle) including installing configuring, maintaining, and troubleshooting and... Read More →

2018 Nelson UTOUG Advanced diagnostic repository pdf

Wednesday March 21, 2018 1:15pm - 2:15pm MDT
0160, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

1:15pm MDT

Oracle Optimizer—Best Practices for Managing Optimizer Statistics

During the optimization of a SQL statement, the Optimizer relies heavily on statistics to estimate the number of rows produced by each of the SQL operators. The quality of the statistics for the objects referenced in the statement greatly affects the quality of the plan. Statistics maintenance is a challenge all DBAs must face in order to prevent the execution plan from becoming suboptimal. This presentation includes information on the features introduced in both Oracle Database 11g and 12c to improve the quality and efficiency of statistics gathering, as well as strategies for managing statistics in various database environments. These strategies include how to use dynamic sampling and when, and how, to manually set statistics directly versus collecting them.

Speakers

Maria Colgan

Master Product Manager, Oracle Corporation

Maria Colgan is a master product manager at Oracle Corporation and has been with the company since version 7.3 was released in 1996. Maria's core responsibility is creating material and lectures on the Oracle Database and the best practices for incorporating it into your environments... Read More →

Best Practices for Manging statistics pdf

Wednesday March 21, 2018 1:15pm - 2:15pm MDT
1180, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

2:45pm MDT

Introducing the Oracle Autonomous Database

Have you heard about the Oracle Autonomous Database? What does this mean to you and how can you benefit from this database offering? In this session you will get the chance to find out from Oracle Database Product Management what the goals for the Oracle Autonomous Database are, along with what Oracle has developed to deliver these capabilities to our customers.

Speakers

Sean Stacey

Oracle Outbound Database Product Manager, Oracle America, Inc

Sean Stacey is a Director of Product Management in Oracle's Server Technologies organization. Sean joined Oracle in 1997, and during his time with Oracle has focused much of his time supporting Oracle's partner community with programs primarily around the adoption of the Oracle... Read More →

Autonomous DB pdf

Wednesday March 21, 2018 2:45pm - 3:15pm MDT
0170, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

2:45pm MDT

Understanding the Oracle Database Release Model and Patching

Starting with Oracle 18c, Oracle has moved to a new release numbering scheme, release model, and patching model for the Oracle database. What does it mean for customers? What is the best strategy? And how will the transition from the old to the new model work? This presentation will map the old release numbering to the new model, describe how quarterly patching will proceed going forward, and give you recommendations for how to adopt new releases. In addition, you will get pointers to all the important support notes and resources that you will want at your fingertips as an informed DBA dealing with upgrades and patching.

Speakers

Maria Colgan

Master Product Manager, Oracle Corporation

Maria Colgan is a master product manager at Oracle Corporation and has been with the company since version 7.3 was released in 1996. Maria's core responsibility is creating material and lectures on the Oracle Database and the best practices for incorporating it into your environments... Read More →

Release Model Patching 18c pdf

Wednesday March 21, 2018 2:45pm - 3:15pm MDT
3170, 3rd Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

3:30pm MDT

Security for Oracle DBAs and Developers

Almost every major break in to an Oracle Database has been performed by persons with a valid user ID and password. These are attacks that cannot be prevented by a LDAP, a firewall, or licensing another product. The best Oracle Database security can be obtained by properly configuring the tools you have already licensed from Oracle, but which were not enabled, by default, during installation. This presentation by Oracle ACE Director Alumnus Daniel Morgan will focus on proper configuration of the tools Oracle has been distributing for more than a decade, including live demos in SQL*Plus.

Speakers

Daniel Morgan

Oracle ACE Alumni, Meta7

Oracle ACE Director Daniel Morgan has more than 25 years' experience working with Oracle products. Dan wrote the Oracle curriculum for the University of Washington, was the program's primary instructor for 10 years, is the Morgan behind the MorgansLibrary.org website, and is currently... Read More →

OracleSecurityforDBAsDevelopers pdf

Wednesday March 21, 2018 3:30pm - 4:30pm MDT
0170, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

3:30pm MDT

Taking ASH Analysis to the Next Level—Plan Change and Parsing Detection/Analysis

Sometimes snapshot time-based (AWR) performance data does not provide the level of detail we need to diagnose performance issues. Usually Oracle Active Session History (ASH) data solves this limitation by providing session-level sample data. However, we can go further by creatively using ASH data to do things that are not possible using standard ASH and time-based analysis. This presentation will demonstrate how to use ASH data to pinpoint SQL plan changes. Also, it will show you how to detect parsing issues before they show up in the wait interface. The presentation includes demonstrations and where to get the free SQL, so you can take your ASH analysis to the next level!

Speakers

Craig Shallahamer

Applied AI Scientist, OraPub/Viscosity

Having worked with Oracle technology since 1989, Craig Shallahamer is a leader in the fields of machine learning, artificial intelligence, and Oracle database performance tuning. Craig has extensive experience in constructing and teaching predictive modeling methods, notably developing... Read More →

Wednesday March 21, 2018 3:30pm - 4:30pm MDT
0180, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

8:30am MDT

Oracle Privilege History

Have you ever dropped a table, user, or role by mistake and tried to restore privileges but couldn't remember what to grant or to whom? You queried the dba views only to find what is currently granted, not what was granted. Now, your only option is to guess which grants to make and then wait for people to complain, or processes to fail so you can figure out which grants were missed. Flashback is helpful, but won’t always solve the problem at hand. Creating a historical record of privileges will allow you to restore the correct suite of privileges to users or roles quickly and accurately without guessing. This presentation will provide steps to set up a process to track privileges historically.

Speakers

Dallin Rogers

Intermountain Healthcare

I graduated from the University of Utah with a Master's Degree in Information Systems. I have been with Intermountain Healthcare for 7 years as a Data Architect on the EDW team. The last 3 years, I have been the EDW Database Operations Lead.Since my arrival, my coworkers have voted... Read More →

UTOUG Oracle Privilege History pptx

Thursday March 22, 2018 8:30am - 9:30am MDT
5180, 5th Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

9:45am MDT

Deploying an Oracle Database in a Docker Container

Containers as a deployment model for applications have gone mainstream. Why not get those same benefits from deploying your Oracle database in a Container? In this session, we will cover the different strategies for deploying an Oracle Database in a Container environment. The session will also include a demonstration of the deployment process.

Speakers

Sean Stacey

Oracle Outbound Database Product Manager, Oracle America, Inc

Sean Stacey is a Director of Product Management in Oracle's Server Technologies organization. Sean joined Oracle in 1997, and during his time with Oracle has focused much of his time supporting Oracle's partner community with programs primarily around the adoption of the Oracle... Read More →

Sean Stacey Docker pdf

Thursday March 22, 2018 9:45am - 10:45am MDT
1180, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

9:45am MDT

Oracle Database Sizing for the Cloud

Learn how to measure the CPU footprint of an Oracle Database to know what size, shape, and how many CPUs are necessary to host your Oracle Database in the cloud.
Attendees will learn how to:

Standardize ASH data
Use percentiles as a technique to calculate CPU requirement
Use the standard SPEC for CPU power conversion between source and target machines

Speakers

Jorge Barba

Accenture, LLP

Jorge Barba is an information technology expert with over 20 years of Oracle experience. Jorge has a bachelor's degree in computer engineering from University of Mexico and a master of business administration from Rollins College in Florida. Jorge's experience includes supporting... Read More →

Thursday March 22, 2018 9:45am - 10:45am MDT
3170, 3rd Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

9:45am MDT

Understanding and Optimizing Oracle Memory Serialization Access (Latches and Mutexes)

Oracle memory serialization control is core to Oracle database operations. One of the most fascinating topics in Oracle internals and performance optimization is memory serialization. We will look at when serialization is used, how it works, how we can influence its operation, and how we can diagnose problems. But, it's a complex situation. To get the upper hand on serialization control, this presentation will explore the lock (a little), the latch (a lot), and the mutex (a whole lot). Topics include performance diagnosis, how Oracle implements latches and mutexes, and the related internal algorithms. Special attention is given to the library cache mutex operations. This is a very practical yet deep internals presentation, filled with amazing discoveries about how Oracle works.

Speakers

Craig Shallahamer

Applied AI Scientist, OraPub/Viscosity

Having worked with Oracle technology since 1989, Craig Shallahamer is a leader in the fields of machine learning, artificial intelligence, and Oracle database performance tuning. Craig has extensive experience in constructing and teaching predictive modeling methods, notably developing... Read More →

Thursday March 22, 2018 9:45am - 10:45am MDT
5130, 5th Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

11:15am MDT

Holistic Database Security

Attack Vector: how does your information leak? This presentation will include an open and frank discussion of organized gangs (e.g. Anonymous).
Risk identification and mitigation: Identify the risks in your system and come up with mitigation strategies. Audit: Identify what to audit, based on your risks. Audit too much and you will get bogged down; too little and you may miss a breach of security.
Database encryption: Encrypting the database, the tablespace, the tables, or atomic data? What is the cost and how do you accomplish it?
Network encryption: What are the risks of man-in-the-middle attack? How to set up network encryption. Backup encryption: What are the risks of losing a backup tape? How to encrypt backups using RMAN.
Data redaction: Who gets to see sensitive data? Do you want to expose credit card numbers or other PII to users? Introduction on how to set up data redaction.
Data masking: Do you refresh the test or QA environment from production? Do you need your testers to have access to your production data?

Speakers

Robert Lockard

Oracle ACE Director, Oraclewizard

Robert P. Lockard is a professional Oracle DBA, designer, developer, and project manager. For the past twenty years he has worked as an independent consultant, providing quality services to his customers at a reasonable price. He's worked in financial intelligence tracking money laundering... Read More →

HolisticDatabaseSecurityWithCustomerQuestions pptx

Thursday March 22, 2018 11:15am - 12:15pm MDT
0170, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

11:15am MDT

Oracle's Cloud Strategy

Now more than ever, organizations must have a strategy and plan for moving to the cloud. What should you put into public clouds? Should you create a private cloud? What are the trade-offs between these different choices? You want to maximize your options and the different approaches you might take to move to a cloud environment. Explore the different stages of the journey to cloud, and how to define your road map to a cloud environment. Examine the trade-offs of the different approaches, whether you need a private, public, or hybrid cloud. See how Oracle's complete offering gives you the broadest set of options for implementing in a cloud.

Speakers

Daniel Liu

Oracle Corporation

Daniel Liu is a principal solution architect at Oracle Corporation and co-author of "Oracle Database 10g New Features" by Rampant TechPress. He has 20 years of experience working with both Fortune 500 companies and public sector entities to apply technology to help solve business... Read More →

Thursday March 22, 2018 11:15am - 12:15pm MDT
0180, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

3:00pm MDT

Saving Your Database from Alzheimer's: Analytic Performance Improvements From Oracle 12cR2 Database In-Memory (DBIM)

Oracle Database 12.2.0.1 (12cR2) significantly improves the performance of Database In-Memory (DBIM) features, offering potentially massive improvements in real-time analytic processing and queries. This session takes a deeper look at what the Oracle 12cR2 optimizer is actually doing “under the covers” when it makes its decisions to process a query against IMCS-resident and nonresident tables, including improved In-Memory Joins, leveraging Join Groups, taking advantage of In-Memory Expressions, and utilizing In-Memory Filtering effectively. We’ll look at some real-world performance improvement metrics obtained against an Exadata Express OPC environment that shows how best to tackle using these newest DBIM features.

Speakers

James Czuprynski

Chief StoryTeller, Zero Defect Computing, Inc.

Jim Czuprynski has 40+ years of professional experience in Information Technology, serving diverse roles at various Fortune 1000 companies before becoming an Oracle DBA in 2001. He has been an Oracle ACE Director since 2014 and is a sought-after public speaker on Oracle technology... Read More →

Thursday March 22, 2018 3:00pm - 4:00pm MDT
0180, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

3:00pm MDT

Upgrade, Migrate, and Consolidate to Oracle Database 12c/18c

This session will provide an overview of how to upgrade, migrate, and consolidate Oracle database from earlier versions to Oracle database 12c/18c. The session will discuss the preparation steps, upgrade/migrate/consolidate strategies, fallback strategies, new features, performance management, patching, etc.

Speakers

Daniel Liu

Oracle Corporation

Daniel Liu is a principal solution architect at Oracle Corporation and co-author of "Oracle Database 10g New Features" by Rampant TechPress. He has 20 years of experience working with both Fortune 500 companies and public sector entities to apply technology to help solve business... Read More →

Thursday March 22, 2018 3:00pm - 4:00pm MDT
5130, 5th Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112