In this session learn what histograms are and how they can be useful to you. Topics covered for Oracle Database 11g histograms include frequency histograms and height-balanced histograms. Topics covered for Oracle Database 12c Histograms include challenges with Oracle Database 11g histograms, top frequency histograms, and hybrid histograms. The session also covers Oracle Database 18c/19c/21c histograms.

We recognize that every organization is different with a unique set of business and strategic requirements for your HCM, ERP (Financials / SCM) and EPM suite of applications, whether you are PeopleSoft, JDE, or EBS, or any other on-premise platform. The future of your HCM, ERP, SCM and EPM has more options than ever on how best to improve your systems, efficiencies, and costs to meet your continually changing business requirements, whether it’s related to application functionality or your infrastructure and platform.

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.

Database I/O latency often posts significant performance bottlenecks on database systems. Oracle Persistent Memory database and the Oracle Memory Speed File system(OMS) introduced Oracle Database 21c and 19c respectively provide the support for Persistent Memory (PMEM) as database storage and significantly reduce database I/O Latency. By mapping database buffer cache directly onto Persistent Memory storage, Persistent Memory Database directly uses data residing in the Persistent Memory storage and eliminates the latency of copying data into the database buffer cache. This session discusses these two features in detail and how we leverage them to achieve the extremely low latency and high throughputs in a high performance database system. This session provides the step by step how-to details of implementing these two Persistent Memory database features, also provides the use cases & performance benefit studies of leveraging these Two features in a high performance database system. We will have some discussions on the Intel latest announcement on Persistent Memory technology and the related future development direction.

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.

The presentation will cover various topics, such as the migration process, performance optimization, cost management, and security considerations. The panelists will also discuss how OCI's advanced features and tools, such as Autonomous Database, Compute Instances, and Load Balancing, have helped them enhance their PeopleSoft environment and streamline their business operations.

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.

Digital transformation is not for the faint of heart. Learn about the strategic value of implementing Oracle Guided Learning to drive target outcomes of your digital transformation. Digitizing your core operations is often just the foundation for offering new or enhanced digital products and services. Strategic business imperatives to reduce costs, improve quality, improve speed-to-market, drive growth, and improve experience often underpin the rationale for digital enablement. The value chain, by necessity, includes the user adoption curve for your critical business technology. Find out more about how Oracle Guided Learning, Oracle's best-in-class digital adoption platform, can enable success for your transforming organization.