Tired of grinding away to try to come up with a database tuning action plan? This presentation details how to get to database tuning actions more quickly by aggregating findings and recommendations across multiple Advisor runs. The author details his custom tools (simple SQL statements) that expose many undocumented features of the Advisor framework. In the DBA or developer’s hands, these tools can massively scale-up your ability to action tuning opportunities exposed by the various Advisors. The excellent findings and recommendations that come out of the various Advisors such as the SQL Tuning Advisor, the Automated Database Diagnostics Monitor (ADDM), the Segment Tuning Advisor, and the SQL Access Advisor will be of particular focus in this presentation.

Enterprise Manager 13.5 is the latest version of OEM that provides a single pane of glass to your Oracle technology stack. In this session , learn what is new in OEM, and how it can be used to monitor your cloud and on premise databases and systems. Learn about key technologies that allows OEM to heal broken system automatically!

Have you ever wanted to know the runtime of your SQL queries without having to instrument your application? If so, this presentation is for you. By analyzing raw ASH data, you can learn how to infer the runtime of your SQL queries and gain valuable insights into their performance.

This presentation will look at which 23c features including True Cache, Locking Enhancements, Schema Level Privileges, Machine Learning Enhancements & more to prepare for in 23c. Many features covered will be related to the DBA, but there are also some that focus on the developer. Also, some 19c new features (automatic indexing, Quarantine, JSON data, Three user-created PDBs, Read-mostly Standby, and Autonomous Databases) that should be investigated for use. This presentation will also have a few 21c new features such as AutoML, Standby Result Cache, and InMemory enhancements including Base Level. There will be simple examples, where possible, to show the basic functionality of the new features. in. We will also look at the autonomous database and Oracle’s focus on the future of security.

Database 21c pluggable databases offer numerous options for the cloud. In this session walk through Multitenant for cloud/on-premises databases. Topics covered include container database (CDB)/pluggable database (PDB) concepts, PDB value, shared/exclusive components, and accessing CDBs/PDBs. The session briefly covers migration options to 12c/21c from previous versions and then delves into Oracle Database 12c R2/21c features including PDB relocate, lockdown profiles, system global area/program global area for PDB, memory I/O resource prioritization, snapshot carousel, dynamic lockdown profiles, CDB fleet management, and new features in Oracle Database 21c if time permits.

When you are working with Oracle Databases you must have your database running in the last version as recommended to avoid extra costs with Oracle Support.

Upgrading a database sometimes is a nightmare for DBAs. In order to upgrade more than one database in the same maintenance window, you may need more than one DBA.

Patching Oracle databases means more than just applying the quarterly bundled Release Updates (RU) or Monthly Recommended Patches (MRP). Many DBAs aren't aware that RU and MRP are not comprehensive and that databases remain exposed to critical vulnerabilities and regressions without supplemental patching.

While 23c is now out, there is still a lot of life in 19c. This session will educate and demo several tricks in 19c that will help both DBAs and Application owners. Tricks like having two passwords on an account at the same time to facilitate password rotations will be covered. Or, if you are a developer how about SQL Macros to encapsulate complex processing logic directly within SQL. Or how about dynamic init parameters based on system resources!

Migration of an Oracle Database is a process that takes significant planning and effort.
In this session, you will learn about migration from Oracle Databases, including examples, free tools, and techniques for easy migration.

Come and hear from Oracle product management about what’s new in the Oracle Database and find out what’s coming in the next release. The session will be covering the latest features in the Oracle Database and will also provide an update on what to expect from the next release of the database.