Oracle Database 19c: New Features for Administrators Ed 1 — Lesson 4: Performance, Automatic Diagnostics, Optimizer, Upgrade, and Adoption Plan

Technical Scope

• automatic indexing concepts, real-time statistics, SQL quarantine, and plan control
• memory, In-Memory, resource management, monitoring, and diagnostics improvements
• AutoUpgrade, prechecks, compatibility, testing, and post-upgrade validation
• feature adoption matrix, risk assessment, operational handoff, and roadmap

Instructor Demonstration

Demonstrate automatic indexing concepts, real-time statistics, SQL quarantine, and plan control within a database operations team assessing Oracle Database 19c features for a controlled upgrade from an earlier release while preserving security, performance, and recoverability, then capture the exact configuration, command, transaction, report, trace, or code evidence that proves the expected result.

Applied Workshop

Implement a controlled workshop covering memory, In-Memory, resource management, monitoring, and diagnostics improvements and AutoUpgrade, prechecks, compatibility, testing, and post-upgrade validation, then test a failure, exception, or business-control scenario involving feature adoption matrix, risk assessment, operational handoff, and roadmap.

1. Confirm the environment, identities, data, dependencies, controls, and expected result.
2. Complete the product-specific configuration, development, analysis, or business-process task.
3. Capture commands, configuration, output, logs, transactions, reports, or test evidence.
4. Explain the operational, security, performance, data-quality, or business trade-off.

Validation Standard

The Performance, Automatic Diagnostics, Optimizer, Upgrade, and Adoption Plan result must be reproducible, traceable to approved inputs, and consistent with expected Oracle product or business-process behavior.

• The intended target, scope, and ownership are verified.
• The result is supported by reproducible evidence and expected-value checks.
• Security, performance, reliability, data quality, and support impact are reviewed.
• Unexpected behavior is investigated before acceptance or release.

Failure Analysis

Diagnose issues in automatic indexing concepts, real-time statistics, SQL quarantine, and plan control, memory, In-Memory, resource management, monitoring, and diagnostics improvements, AutoUpgrade, prechecks, compatibility, testing, and post-upgrade validation, or feature adoption matrix, risk assessment, operational handoff, and roadmap without making an unverified production change.

Learners isolate the smallest proven cause, apply a reversible correction, rerun validation, and record the preventive action.

Practical Outcome

Complete a validated implementation or analysis for Performance, Automatic Diagnostics, Optimizer, Upgrade, and Adoption Plan and defend the result with documented evidence.