Mauro Pagano's Blog

SQLd360 v3 now available, new features and (hopefully) less bugs!


Couple of weeks ago SQLd360 v1 came out and now v3, so what happened to v2? It was a “silent” release to fix a bug and sneak in a couple features I didn’t complete in time for v1 but most of the new features are in v3.
The main page now looks something like thisScreen Shot 2015-02-26 at 10.01.13 PM

so the list of content grew a bit and it will keep growing release after release.
List of bugs (hopefully) shrank as well but no promise on that 🙂

The major additions are

  • Plan Control section reporting info about SQL Profiles, SQL Plan Baselines and SQL Patches
  • Execution plans details from SQL Plan Baselines
  • Time series report/chart for average and median elapsed for the SQL (regardless of the plan), this can help answer the question “how is my SQL doing over time?”
  • Time series report/chart for average elapsed time per plan hash value for the SQL, this can help identify if a change in performance is caused by a plan change
  • A standalone script to execute the SQL from SQL*Plus, the script includes bind variables definition/assignment in case the SQL has binds
  • Cursor Sharing section reporting info from GV$SQL_SHARED_CURSOR
  • Bind datatype mismatch report, this can help identify those cases where apps define binds for the same SQL using different datatypes

plus some other minor reports/tweaks.

Bug fixes here and there, specially in the histograms section where now every endpoint value is (AFAIK, if you see issues let me know so I can fix them!) properly converted and charted so we can leverage charts to analyze histograms 😀
Ie the following one is for SH.CUSTOMERS.CUST_YEAR_OF_BIRTHhistogram

From the chart above we can see how the data is distributed and for each bar(/bucket) the (approximate) value, how many rows belong to each bucket and the selectivity for an equality predicate for that specific value.

More things in the work and as usual feedback/comments/reported issues are very much welcome!!!!

5 thoughts on “SQLd360 v3 now available, new features and (hopefully) less bugs!

  1. Pingback: SQLd360 v3 now available, new features and (hopefully) less bugs! | Christoph's 2 Oracle Cents

  2. Hi Mauro,
    excellent job as usual,but this works only with EE but not with SE, is it right ? Need a Tuning or Diagnostic pack. For the guys which use SE, is there something ?


    • Ciao Alberto!

      You can use SQLd360 with every level of licensing you have, including SE. Some info will be missing but some others will be there and (hopefully) still useful 🙂 Ie. One that I personally like a lot is the chart for histograms bucket, you would still get that as well as all the info coming from memory.


  3. Hi Mauro,
    I just tryed in my SE and all works fine, the chart for histograms bucket it’s simply great !!! better than a thousand words… 😉
    Thanks a lot for sharing
    Another question, what about for RAC enviroment?



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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s