Loading…

Sign up or log in to bookmark your favorites and sync them to your phone or calendar.

DBA [clear filter]
Wednesday, March 21
 

9:45am MDT

Leveraging Partitioned External Tables: Primer and Practical Examples
Oracle Database 12is 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
avatar for James Czuprynski

James Czuprynski

Senior Enterprise Data Architect, Viscosity North America
Jim Czuprynski has 35+ years of professional experience in his career in information technology, serving diverse roles at several Fortune 1000 companies before becoming an Oracle DBA in 2001. He was awarded the status of Oracle ACE Director in March 2014 and is a sought-after public... 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
avatar for Daniel Morgan

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 →



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
avatar for Sean Scott

Sean Scott

Principal Consultant, Viscosity North America
Sean is a database administrator with over 20 years' experience managing Oracle. For 15 years he ran a consulting firm specializing in database technologies, backup and recovery, performance tuning, and database design. He's developed high-performance solutions to meet the extreme... Read More →



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
avatar for Maria Colgan

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 →



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
avatar for Michael Nelson

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 →



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
avatar for Maria Colgan

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 →



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
avatar for Sean Stacey

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 →



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
avatar for Maria Colgan

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 →



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
avatar for Daniel Morgan

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 →



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
avatar for Craig Shallahamer

Craig Shallahamer

President/Founder/DBA, OraPub, Inc.
Craig is a long time Oracle DBA who specializes in Oracle tuning and started the OraPub website in 1995. Craig is a performance researcher and blogger, consultant, author of two books, an enthusiastic conference speaker and a passionate teacher to thousands of Oracle professionals... Read More →


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

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
DR

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 →



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
avatar for Sean Stacey

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 →



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
avatar for Jorge Barba

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 →


Sizing pdf

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
avatar for Craig Shallahamer

Craig Shallahamer

President/Founder/DBA, OraPub, Inc.
Craig is a long time Oracle DBA who specializes in Oracle tuning and started the OraPub website in 1995. Craig is a performance researcher and blogger, consultant, author of two books, an enthusiastic conference speaker and a passionate teacher to thousands of Oracle professionals... 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
avatar for Robert Lockard

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 →



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
DL

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
avatar for James Czuprynski

James Czuprynski

Senior Enterprise Data Architect, Viscosity North America
Jim Czuprynski has 35+ years of professional experience in his career in information technology, serving diverse roles at several Fortune 1000 companies before becoming an Oracle DBA in 2001. He was awarded the status of Oracle ACE Director in March 2014 and is a sought-after public... 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
DL

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