In this session, you’ll learn how MySQL HeatWave provides a single database service for transaction processing, analytics, machine learning, and data lake applications. It eliminates the complexity of ETL operations and existing MySQL applications run without any changes. MySQL HeatWave provides the best price-performance among competing offerings and is offered on multiple clouds.

One of the most critical aspects of building effective systems is the successful management of semi-structured information. The database is no longer only a place to store dollars and cents for the purposes of accounting. Efficient manipulation of XML and JSON has become one of the most critical elements of contemporary database infrastructure – and in the majority of cases XML or JSON internally are implemented as LOBs. However, few people in the development community really understand the underlying mechanics of Oracle LOB datatypes and consider it yet another DBA issue. This presentation attempts to fill that knowledge gap.

You will probably be surprised by what you learn in this session. Oracle offers a comprehensive portfolio that enables you choice. Enterprise Manager is our flagship on-premises management product for databases and Engineered Systems that 10s of 1000s of customers rely on every day. OCI Database Management is a cloud-native on-demand managed cloud service that provides single a management view for Oracle Databases on-premises, in the cloud, and in multicloud environments enabling users with real-time performance diagnostics and administration capabilities. Presented by the subject matter experts, get your questions answered and learn which is the better solution for your needs.

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.