Transform your ability to quickly respond to the challenge of ensuring high performing DB’s. The key to this transformation is to expertly use the advisor framework which underlies tools such as ADDM, SQL Tuning Advisor, Segment Tuning.  These tools provide actionable advice to the DBA seeking to solve performance problems, but getting at this information can be painstaking.  This presentation shows you many undocumented ways to proficiently use the underlying data to quickly get to tuning solutions.

How often do you get the chance to start over and do things the way you want?  That's what we did with Unified Audit in Oracle Database 12c.  Join us to review why we created this greaet new feature, learn about some of the many things you can do with Unified Audit, and hear our…

Oracle Database In-Memory promises an incredible performance boost for analytic queries. But how do you determine if you have an analytic workload that will benefit from Database In-Memory? This presentation will review what Database In-Memory is and how it works, and then we will talk about what types of workload will benefit from Database In-Memory. We will also examine what aspects of a SQL query benefit from Database In-Memory and provide some guidelines for use with commercial applications and applications where you cannot change the code. Lastly we will take a look at some actual SQL Monitor reports to demonstrate where Database In-Memory provides benefit and show how a time-based approach can be used to help quantify the benefit of Database In-Memory.

Visualizing Air Traffic Data with the FAA’s Satellite-based Surveillance System, the Oracle IoT Cloud,  a Cardboard Pizza Box, a Raspberry PI, and APEX.  Track weather and assets in the field without spending a ton of money?  We connect a raspberry PI to the FAA’s network and utilize a radio based interface to track business aircraft…

With Oracle Database 19c a new tool will become available: The AutoUpgrade Tool will upgrade hundreds and thousands of databases or PDBs fully unattended automatically. You will only need one config file. And everything else, from preupgrade to fixups to upgrade and finally postupgrade and time zone adjustments, everything gets handled by the tool. Regardless…

It's now easier than ever to host many test environments comprised of a multitude of platforms and database versions using virtualization. On anything: even your laptop or a consumer grade NAS. VMs and Containers are both good options. DBAs and Developers can still manually build VMs using VirtualBox but Vagrant makes the process much easier…

Relational Databases are extremely sophisticated, but their extensive functionality makes it challenging for them to achieve hyperscale. Some have turned to alternative technologies such as key value stores, which exclude most of the functionality of Relational Databases in order to make scaling easier. However, increasingly more people are seeking a solution that achieves extreme scalability…

Recent Oracle Database releases include significant new features that streamline user administration, reduce database attack surfaces, and protect personally identifiable information, and other sensitive data. In this session learn about the new way to authenticate and authorize database users in Active Directory. Explore review recent security innovations including privilege analysis, database vault simulation mode, data…

Get hands-on and learn the features of the Python cx_Oracle interface for Oracle Database. In this session learn efficient techniques for connection management, statement handling, and more. If you want to use Python and Oracle Database, this session is for you. Basic programming skills in any language are required.

This presentation will look at which 19c new features that should be investigated for use.  This presentation will also look at which 18c new features that should be investigated for use (such as Snapshot Carousel, PDB Switchover, In-Memory External Tables, Merge Partition Online, Advances in the Approximate Query, Polymorphic Tables, Standby Nologging, and Password-less Schema Creation…