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 un…

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 s…

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 fea…

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 se…

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.

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 p…

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…

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.