DBMS Tuning & My Life

Posts Tagged ‘$SQL_PLAN_STATISTICS_ALL

Excel Macro for analyzing the v$sql_plan_statistics_all view.

leave a comment »

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.

plan1

plan2

Written by sean70kim

July 4, 2013 at 9:43 am

Posted in Oracle

Tagged with ,