The new DBMS_SQLDIAG function REPORT_SQL is now available in Oracle Database 19c from RU 19.28.
It’s a great utility for diagnosing plan changes and SQL performance issues.
You can find more information on Ulrike’s blog post.
SQL Diagnostic Report Now Available in Oracle Database 19c
Authors
Nigel Bayliss
Product Manager
Nigel is the product manager for the Oracle Optimizer. He's worked with Oracle technology since 1988 and joined Oracle in 1996. He's been involved in a wide variety of roles including development, benchmarking, consulting and pre-sales.
Previous post