Vishal desai’s Oracle Blog

October 3, 2014

Compare Oracle SQL Plan in Excel

Filed under: Performance Tuning, Tools — vishaldesai @ 2:36 pm


Input Screen:




Output Screen:


Download xlsm file, input source and target details, double click on list box to populate plan hash values and select one item and click on Run button to compare plan. The output screen will highlight first line (only first) where it finds difference in operation.



  1. Hi Vishal,

    Trying to use the tool but i get below error…i am able to fill in all the details except the Plan Hash value…i cant fill that or click in the box…

    Run-time error ’94’:

    Invalid use of Null

    see below for screenshot…

    Comment by Max Scalf — November 19, 2014 @ 2:18 pm

    • Hi Max,

      Make sure you have tns entries in tnsnames.ora file on your client machine.

      After entering sqlid, double click inside Plan Hash 1 list box, select one plan hash value then double click on plan hash value 2, select second plan hash value and click on run.


      Comment by vishaldesai — November 20, 2014 @ 12:57 am

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at

%d bloggers like this: