Posts Tagged ‘$SQL_PLAN_STATISTICS_ALL’
Excel Macro for analyzing the v$sql_plan_statistics_all view.
In my previous article, I described how to get delta values from v$sql_plan_statistics_all view. And, I made the excel macro for more convenient tuning life. The macro provides delta values, as well as IO statistics about objects and operations. The sample output is as follows:
To use the macro, just input {TNSNAME, USREID, PASSWD, SQLID} then click “Click” button. If you want to use this macro, you can download from here.