Database & Technology Week 2022

Get up to date on recent Oracle Database news and developments. Get a sneak preview—directly from the Oracle Database development team—of what’s coming in the next major release of Oracle Database.

Ransomware is the #1 cyber-threat facing most organizations, and your databases are not immune from it. With dozens of new attacks each day—and increasing pressure from shareholders, executives, and the board of directors to protect critical assets—it’s important to ensure your databases are protected and that you can resume business operations quickly after an attack. Join us to learn more about the threat and what you can do to protect yourself.

Oracle 12c R2 offers many enhancements in the In-Memory option. Oracle ACE, Anuj Mohan will point out performance-related problems and explain how Oracle 12c R2 In-Memory option can help with these problems. The session will talk about the overall In-Memory option along with the below enhancements Dynamic Sizing of In-Memory area IM support for Active Data Guard Optimize joins performance via Join Groups IM Expressions IM Fast Start. #DB&TWeek22

Oracle Database Platform Cloud Services is among the most stable, mature, and efficient services on Oracle Cloud Infrastructure (OCI). Customers large and small, regional and international have proven that moving your databases and related infrastructure to Cloud is the right thing to do. So what are you waiting for? Learn about the advantages of Cloud database platform service, use cases for moving to Cloud, migration options, planning considerations, best practices, when to consolidate, when to transform, whether to use Autonomous DB, ADW, Exadata CS, and more. Understand how OCI helps you improve database performance, databsae security, automates maintenance, and frees up your DBA time to work on value-added projects.

The Oracle Cloud Database Management service reduces the tools and burden on DevOps and DBA staff by providing database lifecycle management abilities encompassing monitoring, performance management, tuning, and database administration. In this session learn how to manage existing databases onsite while also keeping databases deployed in the cloud maintained and secured. #DB&TWeek22

Join this session to get a unique insight into Oracle Autonomous Database’s data security spectrum. Learn about the advanced security controls in your Autonomous Database subscription, including Database Vault, Label Security, Centrally Managed Users, Immutable Tables, and much more. Discover how these capabilities, along with Data Safe, and integration with Identity and Access Management come together to help reduce the risk of insider and outsider threats and address common compliance requirements

“Modern app dev and microservice architectures have made observability an absolutely critical requirement for DevOps. Currently, there are a number of disparate tools which can make this difficult and inefficient. Furthermore, app and database observability tools are currently quite different and separate, as are on-prem and cloud-based tools.Grafana provides a single-pane-of-glass view of metrics, logs, and tracing with the ability to correlate and drill-down between them. Further, Oracle’s open source Unified Observability Exporters provide metrics, logs, and tracing into the database thus providing a highly-customizable end-to-end observability experience that is unique in the industry and entirely cloud native. In this session, we will describe the details of this solution and the simplicity involved in setting it up.”

Xerox’s cloud first strategy involves multiple on-prem and public clouds. Recently, Xerox migrated some of their VMware landscape to Oracle Cloud VMware Solutions (OCVS). Learn how Xerox ported existing applications, extended cloud flexibility, and utilized familiar toolsets with Dell Date Protection Suite on-prem to the public cloud. Discover insights and best practices on how Xerox moved VMware workloads to OCVS and supports operational consistency for any workload to back up in the same manner whether in OCVS, public cloud(s), or on prem with Dell Technologies solutions.

Join us for our bi-monthly Maximum Availability Architecture (MAA) SIG meeting!
Exploring Rolling Upgrade – Upgrade your Database with near Zero Downtime
The average time to perform a database upgrade is one to two hours. This downtime would not be acceptable for many organizations as it could significantly impact businesses. In this session, we will cover one of the little-known gems within the Oracle Database that database professionals can use to address downtime. The rolling upgrade feature significantly reduces downtime during an upgrade from hours to minutes. Come and join us to discover how this feature can change the way your company does database upgrades forever!
#DB&TWeek22

In this presentation, we will learn how to use MySQL Heatwave in Oracle Cloud Infrastructure (OCI). We will set up 3 node InnoDB Cluster for ZERO data loss using High Availability, and will cover the steps to test failover.
Also, we will discuss Asynchronous Replication set up and fail over steps. Basic understanding of OCI, VCN, Instances, MySQL Heatwave will be covered as we go through the set up of HA. #DB&TWeek22

Oracle APEX Application Development 22.2 introduces several new features and many enhancements to existing functionality. The new workflow approval component allows developers to easily integrate task management into their APEX applications. Further enhancements to progressive web apps (PWAs) enable a more native mobile user experience for end users. The new application search functionality provides declarative search functionality and a new “Invoke API” process type enables developers to easily map stored procedures to APEX form items. We’ll share a comprehensive overview of the features introduced with this release and will include several demonstrations of our new capabilities.

At Oracle, we strive to provide you with the best database experience no matter where you choose to deploy – on-premises, in Oracle Cloud, or across clouds, using a Multicloud approach. Join this session to understand how you can benefit from Oracle’s years of experience providing the highest availability for on-premises Oracle Databases when deploying your mission-critical databases in Multicloud environments. Learn how easily other Oracle customers could lift and shift their applications and Oracle Databases using solutions such as Oracle Zero Downtime Migration (ZDM) and immediately benefit from Oracle’s industry-leading disaster recovery, high availability, and scalability solutions.

Join us for our monthly Cloud Computing SIG meeting! #DB&TWeek22

In this session, hear how Oracle continues to invest in Enterprise Manager (EM), Oracle’s on-premises hybrid management solution for the Oracle stack, releasing new capabilities and support on a monthly cadence using the agile Release Update (RU) model. EM continues to grow and evolve to address hybrid management needs and the manageability of the environments of tomorrow. Learn how Oracle’s Cloud Infrastructure (OCI) Observability and Management platform provides comprehensive visibility and insights across all layers of the stack—deployed on any technology, anywhere. By unifying all types of operational telemetry (metrics, logs, traces) with curated machine learning–based analysis, enabling you to manage databases and applications easier on-premises, on Oracle Cloud or Multi-cloud environments.
– Understand Oracle’s current offerings and plans to provide manageability across hybrid estates leveraging the best of on-premises and cloud technology
– Learn how EM helps you lower the cost and risk of providing high-performance applications and adopting the latest Oracle technology
– Understand how O&M provides a unified view across an entire software stack, provides improved insight for Exadata solutions
– Quickly get up to speed on the O&M services already available and what’s coming
– See how you can start using O&M services to solve business problems in a matter of minutes

New to tuning SQL, or maybe this is your 10th year? In this session we will give a quick intro on SQL and Oracle Optimizer and then provide some specific examples and tips for multiple SQL tuning options and methods. The goal is for this session to be approachable by all levels of skill and provide some quick take aways without going too deep into any one area. Example code will be provided, with some demonstrations.

Learning goals include: What is SQL tuning; What tools should I use; Explain Plan Lies; Statistics + Histograms = +1; Tuning Advisor + AWR top N SQL = +1; Why do SQL Profiles fail; Create a SQL Baseline from cursor cache; How to make a SQL Patch; Playing with Optimizer; Why is my index not being used? (Index clustering)

Join us for our monthly Oracle Database 19c SIG meeting! #DB&TWeek22

In this session learn how easy it is to utilize machine learning to help you optimize IT spend on database, compute, and Exadata resources in on-premises and cloud (hybrid) environments using OCI Operations Insights. Understand how to perform automated detection of current and impending resource utilization issues as well as how to trend and forecast future resource demand globally across large fleets or at an individual database/host level. See how to detect seasonally sensitive demand and identify over- and underutilization.

Oracle Database has so many security features and products but sometimes the very basics are overlooked. Oracle Database 19c, 21c, and the upcoming 23c brings in even more security features and options. In almost all deployments there are opportunities for immediate security improvements, or hardening, without requiring additional products or options. This presentation covers some key quick-wins (and security tricks) that DBAs can implement immediately to increase their overall Oracle Database security posture and reduce exposures. Applicable to almost all versions and editions.

The session would be to demonstrate-
1. Oracle Database 23c new feature: JSON Relational Duality
2. Oracle Database 23c new feature: Oracle In-Database Graph
Following on from the Database Roadmap and New Features session, we ran out of time to show demonstrations of the new Database 23c capabilities: JSON Relational Duality and Oracle In-Database Graph. This mini-session is for those people who are interested in seeing the demonstrations, but missed out on Monday’s session.