Database Performance Script vini_coe_load_sql_baseline: Extending coe_load_sql_baseline capabilities – A Practical Fix for SQL Plan Regression from AWR Hi everyone, Hope you're doing good. The issue: new SQL ID with bad execution plan A couple of months ago, I had a call from a client regard… Jul 28, 2025 7 min read
Database Performance LogMiner Eating Up the CPU Hi everyone, Hope you're doing good! A few days ago, a client complained about a slowness in their SAP DB environment running on Oracle. DB … Apr 14, 2025 4 min read
Database Performance Finding the Needle in the Haystack: Troubleshooting Performance Issues with ASH and dashtop.sql Hi all, I hope you're doing good. After a client migrated their main database to RAC (they just did the switchover from Single Instance to R… Mar 17, 2025 3 min read