See discussions, stats, and author profiles for this publication at: https://www.researchgate.
net/publication/392937528
Post-Migration Performance Tuning for Oracle 19c
Article · June 2025
CITATIONS READS
0 77
1 author:
Harrison Blake
Harvard University
228 PUBLICATIONS 21 CITATIONS
SEE PROFILE
All content following this page was uploaded by Harrison Blake on 23 June 2025.
The user has requested enhancement of the downloaded file.
Post-Migration Performance Tuning for Oracle 19c
Harrison Blake
Abstract
Post-migration performance tuning is a crucial step in ensuring that the newly migrated Oracle 19c
database meets or exceeds the performance of the previous system. This article defines key strategies
and tools used in tuning Oracle 19c for optimal performance after migration.
Introduction
Database migration often introduces performance variances due to differences in architecture,
execution plans, optimizer behavior, and resource configuration. Oracle 19c introduces new features
and parameters that must be carefully adjusted to align with application demands and infrastructure
capabilities.
SQL Plan Management
SQL Plan Management involves capturing and maintaining execution plans to ensure consistent
performance by preventing regressions in SQL behavior after migration.
Automatic Indexing
Automatic Indexing is a self-learning feature in Oracle 19c that identifies performance bottlenecks
and creates or drops indexes autonomously to optimize query execution.
Optimizer Statistics Gathering
Optimizer Statistics Gathering ensures the cost-based optimizer receives current and accurate data
statistics, which are critical for efficient execution plan generation.
Initialization Parameter Tuning
Initialization Parameter Tuning involves reviewing and adjusting database parameters such as
memory allocation, parallelism, and optimizer modes to match new workload patterns.
Memory Configuration
Memory Configuration includes evaluating and tuning memory structures like the System Global
Area (SGA) and Program Global Area (PGA) to ensure sufficient resources for caching, sorting, and
processing.
AWR and ADDM Reports
AWR and ADDM Reports provide insights into system performance trends and pinpoint areas of
inefficiency, enabling targeted tuning actions.
Resource Manager Configuration
Resource Manager Configuration allows allocation of CPU and I/O resources to specific users or
workloads to prevent contention and ensure quality of service.
Concurrency and Parallel Execution Tuning
Concurrency and Parallel Execution Tuning focuses on maximizing throughput for multi-user
workloads and tuning degree of parallelism to balance performance with resource usage.
References
1. Oloruntoba, Oluwafemi, and Olasehinde Omolayo. "Unlocking Performance and
Uptime: A Strategic Approach to Oracle 12c to 19c Migration for Maximizing ROI."
This paper is an original technical whitepaper completed in March (2024).
2. Laszewski, Tom, and Prakash Nauduri. Migrating to the cloud: Oracle client/server
modernization. Elsevier, 2011.
3. Freeman, Robert. Oracle Database 11g New Features. McGraw-Hill, Inc., 2007.
4. Kansara, M. A. H. E. S. H. B. H. A. I. "A structured lifecycle approach to large-scale
cloud database migration: Challenges and strategies for an optimal transition."
Applied Research in Artificial Intelligence and Cloud Computing 5, no. 1 (2022):
237-261.
5. Fernandez, Iggy. Beginning Oracle Database 11g Administration: From Novice to
Professional. Apress, 2009.
View publication stats
6. Oloruntoba, Oluwafemi, and Olasehinde Omolayo. "Unlocking Performance and
Uptime: A Strategic Approach to Oracle 12c to 19c Migration for Maximizing ROI."
7. Vaidyanatha, Gaja Krishna, and John A. Kostelac. Oracle Performance Tuning 101.
McGraw-Hill Professional, 2001.
8. Niemiec, Richard. Oracle database 10g performance tuning tips & techniques.
McGraw-Hill, Inc., 2007.
9. Dumitras, Tudor, and Priya Narasimhan. "No downtime for data conversions:
Rethinking hot upgrades." Parallel Data Laboratory (2009): 1-8.
10.Niemic, Rich, and Bradley D. Brown. Oracle Performance Tuning Tips and
Techniques. McGraw-Hill, Inc., 1999.
11.Alapati, Sam, Darl Kuhn, and Bill Padfield. Oracle Database 12c Performance Tuning
Recipes: A Problem-Solution Approach. Apress, 2013.
12.Kansara, Maheshbhai. "Advancements in cloud database migration: Current
innovations and future prospects for scalable and secure transitions." (2024).
