Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29
August | 2019 | Oracle DBA – Tips and Techniques
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Oracle 19c New Feature Compare Execution Plans with DBMS_XPLAN.COMPARE_PLANS

  • Posted by Gavin Soorma
  • On August 12, 2019
  • 0 Comments
In Oracle 19c, a new sub-program called COMPARE_PLANS has been added to DBMS_XPLAN. With this new functionality, we can take a reference plan and compare it with some other execution plan – it could belong to a SQL statement already executed where we obtain the plan from the Cursor Cache or from the AWR history […]
Read More