Virtual Classroom Series
Upgrade to Oracle Database 19c

Overview:

Title: Release Strategy and Patching Best Practices

Duration: 99 mins

Description:

Software currency – everyone wants to have access to the latest and greatest and Oracle Database users are no different. In the past, the Oracle database had a long time between releases but included hundreds of new features and improvements. This long release cycle led to less agility in meeting customers’ requirements in the ever-changing IT landscape.

To address this challenge, Oracle has moved to a yearly release cadence allowing us to better meet your database requirements.

At the end of this 90 minute virtual classroom, you'll have a clear understanding of the new release model, its implications and the inherent agility it delivers.

This interactive session will overview what the new release model entails:

• Understand the difference between Interim and Long-Term Support Releases
• What are Release Updates and Release Update Revisions and which one should you choose?
• Patching basics and principles
• Data Patch – what is it good for?
• Oracle Java VM (OJVM) patching improvements

Speakers:

Overview:

Title: Upgrade to Oracle Database 19c using AutoUpgrade

Duration: 108 mins

Description:

Oracle Database 19c Upgrade Virtual Classroom - Session 2: Upgrade to Oracle Database 19c using AutoUpgrade

Oracle Database 19c is a milestone in Oracle’s transition to a more agile release strategy. As the first Long Term Support release, Oracle 19c is ‘the’ release to upgrade your databases to leverage the latest features and get the most out of premier and extended support.

This interactive 90 minute session, we will cover the AutoUpgrade tool. AutoUpgrade, as the name implies, enables Administrators to automatically upgrade one, or many databases in a repeatable and controllable manner. You will be guided through how to build a control file – and then showed how to kick off the upgrade process.

Facilitators will also share AutoUpgrade tips and tricks, alternative upgrade methods and most importantly, fallback & failure planning. As with any major technology upgrade, a fallback plan is a vital and reduces risk.

Finally, we will talk about customers successfully using the AutoUpgrade tool today to automate their move to Oracle 19c regardless of the platform – On-Prem, Exadata, Oracle Cloud and anywhere in between.

Topics that will be covered during this session:

• Discover the power of the new AutoUpgrade tool
• Database Upgrade Tips and Tricks
• What if something goes wrong?
• AutoUpgrade in action (demonstration)

Speakers:

Overview:

Title: Performance Stability, Tips, Tricks & Underscores

Duration: 121 mins

Description:

Oracle Database 19c Upgrade Virtual Classroom - Session 3: Performance Stability, Tips, Tricks & Underscores

Change is the root of all opportunity, at least as far as technology goes. For databases, upgrades and patching bring with them the possibility of unexpected behavioural changes and an improvement in performance. In the worst-case scenario change can mean performance degradation and poor user experience.

To ensure that the worst-case scenario is less likely, Oracle Database includes multiple tools to help administrators baseline SQL performance prior to upgrade, lock SQL execution plans and perform comparative testing to reduce risk during upgrade and patching windows.

In this session, you will learn how to perform proactive testing before upgrading to Oracle 19c. We will share how real application testing can be used to take the guesswork out of change.

Using the SQL Plan Management features such as SQL Plan Baselines & Plan Evolution, we will prevent performance regressing by leveraging known execution plans while ensuring change is introduced in a controlled manner.

Facilitators will share their tips, tricks and underscore parameters to help you get the best out of Oracle Database 19c with an interactive Q&A session.

Topics that will be covered during this session:

• Testing Principles
• Ensure Performance Stability
• SQL Plan Management
• Real Application Testing
• Tips, Tricks & Underscores

Speakers:

Overview:

Title: Migrate to Multitenant Architecture

Duration: 124 mins

Description:

Oracle Database 19c Upgrade Virtual Classroom - Session 4: Migrate to Multitenant Architecture

Oracle Database 19c is the final release to support the non-CDB (Container Database) architecture. Now is the time to start planning and migrating your databases in to the Multitenant architecture introduced in 12cR1.

Oracle Multitenant allows a higher degree of database consolidation than has been previously possible. This leads to several benefits including:

• Reduction in hardware required
• Greater resource sharing and less silos
• Agile database provisioning
• New Upgrade and Patching options
• Scalable management features

In this session we will cover the basics of the Multitenant architecture: What is a container? What is a pluggable database and how do you use them? How does management change in this new world? How do you develop a fallback plan?

Finally, we’ll discuss Multitenant best practices – including how to use the 3 “free” Pluggable Databases in every Oracle Database 19c.

Speakers:

Overview:

Title:Oracle Database 19c Upgrade Virtual Classroom: Migration Strategies: Insights, Tips and Secrets

Description:

In the fourth summer webinar about Multitenant, we touched on some migration strategies. And now it's time for us to dig deeper. We'd like to offer you further insights and a deep dive from a technical point of view, starting with Data Pump and Transportable Tablespaces, then Full Transportable Export Import, and adding RMAN Incremental Backups to decrease the downtime. Best practices and real-world experience will round up this two-hour webinar.

Overview:

Title: Top 5 Reasons to Migrate to Oracle Database 19c

Description:

For decades, customers have relied on Oracle to provide the best performance, scalability, reliability and security for all their operational and analytical workloads. Join this webcast to learn:

• Why upgrading to 19c is important to your business
• The gains in technical efficiencies that come from leveraging a Multitenant architecture
• The advanced analytic features now included with every Oracle Database

Overview:

Title:Revolutionizing Data Driven Insights with Machine Learning and Augmented Analytics

Description:

Machine Learning and Augmented Analytics are key industry trends enabling organizations to differentiate themselves by working smarter. Oracle takes a unique approach that balances the business needs of a citizen data scientist with the more sophisticated development and deployment needs of professional data scientists.

Overview:

Title:Top 10 data types supported by a Converged Database

Description:

Watch this on-demand webcast to learn:

• The different data types and workloads supported by the Oracle Converged Database
• Why this unified approach, rather than a series of many single-purpose “best-of-breed” databases, "future-proofs" your technology investments
• Why analyst consistently rate Oracle highest across all data types and workloads

Overview:

Title:Built in Machine Learning: A Smarter Way to Support Evolving Business Requirements

Description:

Learn how built-in machine learning capabilities of the Oracle Converged Database reduces the complexity and time required to support rapidly changing business requirements. With build-in machine learning and embedded analytic tools data scientists and AI developers can develop machine learning algorithms that leverage data from existing applications and real time external sources.

Join this on demand webcast to learn:

• The significant advantages of a database with built-in machine learning
• How different types of data can be leveraged by machine learning algorithms to create prediction models and analysis
• Why a converged database provides an ideal platform for developing real time machine learning algorithms that are relevant vs special purpose platforms that operate on stale data

Overview:

Title:Turn Data into Information with Oracle’s Converged Database

Description:

Oracle Converged Database is the ideal platform for turning data into meaningful business information

A unified data management platform can help organizations more quickly derive meaning from their data assets.

Watch this webcast to:

• Learn how the Oracle Converged Database supports multiple data types and multiple workloads
• See how your organization can use the built-in functionality of the Oracle Converged Database to easily display, analyze and manage all your data
• Get started with Oracle Spatial, Application Express, Machine Learning, and In-Memory using Multitenant and Docker containers
• Experience using JSON, GeoJSON, Node.js, and Python within a single, unified environment