ADDM* regularly runs behind the scenes and persists various performance tuning solutions that often go unnoticed by the DBA. Since DB performance problems can escalate quickly, the use of these persisted solutions can transform the DBA’s ability to skillfully devise a tuning action plan. To leverage these preexisting solutions, the presenter “reverse engineered” the advisor framework and developed some SQL queries that will help the DBA evaluate the solutions and extract the details and/or SQL needed to implement the solutions. This presentation takes a deep dive into the various ADDM tools, and details these custom queries against ADDM base data. Every DBA will leave this presentation with more confidence, new tools and approaches for solving Oracle database application performance problems. *ADDM (Automated Performance Diagnostics and Monitoring) is a key component in Oracle’s implementation of a self-managing database [part of the Diagnostics and Tuning pack license]. Within the persisted ADDM data, one will find solutions from automatic runs of the SQL Tuning Advisor , Segment Tuning Advisor, hourly ADDM runs, and more.

Need to manage the performance of a consolidated Oracle RAC database cluster? Need to get notifications of DB response time abnormalities such as a switched execution plan? Need to manage rank workloads and ensure the most business critical are meeting SLAs? This session is for you as it will present the QoS Management functionality built into Enterprise…

In this session, you will learn how to upgrade your existing OEM environment using a two system out of place strategy.  We will go over the details of how TDS Telecom successfully migrated our existing OEM test and production environments into a single new 13c environment. During the migration our existing 12c environments and the…

Run RAC? Do you have multiple RAC clusters and want to learn what's new with the technology? Do you want to control application resources from your RAC system? This session covers 10 new technologies in the latest version of RAC. Included are updates to how you patch, monitor and even deploy RAC on your servers. The session also covers storage changes to RAC. Learn how the latest generation of RAC includes an Autonomous Health Framework for improving the reliability of RAC clusters.

The Oracle Autonomous Health Framework (AHF) is a major enhancement in ensuring database performance and availability introduced with the Oracle Database 12c Rel. 2. This session will explain and demonstrate how incorporating applied machine learning techniques in Oracle Cluster Health Advisor, Hang Manager and Trace File Analyzer, autonomously and automatically preserves availability SLAs especially in consolidated or cloud database deployments.

As IT infrastructure expands to new IaaS, PaaS, and SaaS platforms from multiple vendors, the surface area of risk and threats also increases. Meanwhile, security teams have to contend with silos of visibility and weak monitoring across distributed cloud assets. Unified security monitoring is critical to detecting modern threats that are rapidly evolving to exploit…

RMAN as most know it, is one of the most important utilities in a DBAs arsenal. In earlier releases it is fair to say that occasionally it did create havoc and some DBA's were afraid to use it. Is it too complex? “Backup database” - does not look to complex does it? In Oracle Database 12c, Multitenant was introduced and RMAN received a lot of attention with exciting new options. From full to partial backups, using cumulative or differential incremental backups, image copies or backup sets, in this session we will demonstrate how you can use RMAN to help protect your data as well as manage backup and recovery of your Oracle Database 12c Multitenant environment - including backups in cloud based solutions.

There are often challenges getting applications and clients to talk to our databases. This presentation teaches the basics of the Oracle Server networking by discussing the various components of OracleNet. We will discuss the various ways to connect to the database through the network and some tips to help simplify many of the challenges Oracle networking can pose. #IOUGeniusDBBeginner Certificate

Ever hear the phrase, "When I test, I test in production?" It can be a great way to test an upgrade or migration before you take the outage on your production system. In this session you will learn how the Electric Reliability Council of Texas not only reduced their outage window but also gained confidence…

This panel from the Electric Reliability Council of Texas show how they improved application resiliency by harnessing the features of Oracle 12c Real Application Clusters (RAC) and the Universal Connection Pool (UCP). The results of this project improved the ability for the application to continue during episodes of infrastructure outage.