Making Sense of Oracle SPM Auto Evolve Report
Learn how to review SPM Auto Evolve Report results faster using a DBA-friendly summarizer script for DBMS_SPM.REPORT_AUTO_EVOLVE_TASK.
Performance
High Load on Oracle Standby: I/O and RECOVERY_PARALLELISM
Learn how high load on a mounted Oracle standby can be caused by redo apply parallelism, not slow storage. This blog reviews iostat, I/O queuing, and how tuning recovery parallelism…
ORA-01555 on Standby
ORA-01555 on standby explained. How redo apply lag, missing standby redo logs, and undo retention impact query consistency in standby.
Analyzing KEEP CACHE with V$DB_CACHE_ADVICE
How to optimize Oracle Database performance using KEEP Cache by identifying candidates and troubleshooting common issues.