Oracle EBS 12.2 on 19c CDB/PDB (Database Performance Tuning)
Oracle EBS 12.2 on 19c CDB/PDB Database Performance Tuning - Step-by-Step DBA Runbook Prepared by: Bidhan Mandal | Oracle Core DBA & Apps DBA Rules before you start: Change ONE thing at a time. Take AWR snapshot before and after every change. Backup SPFILE (CREATE PFILE FROM SPFILE) before parameter changes. Test in UAT first. AWR/ASH/ADDM/SQL Tuning Advisor need Diagnostics + Tuning Pack licence. Step Index Step Area Goal 1 OS / Server Confirm CPU, memory, swap, I/O are not the bottleneck 2 CDB / PDB health Instance, PDB open mode, alert log, errors 3 Live sessions & waits Find what sessions wait on right now; blockers 4 AWR / ASH / ADDM Find bottleneck over time window 5 Top SQL tuning Fix bad plans, use SQL Tuning Advisor, SPM baseline ...