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.

Whether your Peoplesoft or JD Edwards application environments are on your premises, on the cloud, or hybrid combination they need to be monitored and it’s best to do it using a single solution. Oracle Cloud Infrastructure (OCI) Application Performance Monitoring (APM) provides the ability to monitor the application stack, perform synthetic and End User Monitoring and enable tracing to help diagnose performance issues faster and deliver a consistent level of service. APM enables monitoring of multiple components and application logic spread across clients, third-party services, and back-end computing tiers, on-premises or on the cloud.

Presented at BLUEPRINT 4D
Session ID: 103410