Jagjeet's Oracle Blog!

December 8, 2015

SQL Dashboard V2.1 (beta)

Filed under: Uncategorized — Jagjeet Singh @ 6:54 pm

I have added colored graph and a couple of more metrics related to SQL plan management, Temp/PGA space..etc

Still in-working but pretty stable.

PS : Diagnostic & Tuning pack required.

Download Link : V2.1





  1. Nice! Thank you!

    Comment by chicomajo73 — December 8, 2015 @ 7:42 pm

  2. Hi Jageeth, Nice tool, can you help me how to install the tool, the package doesn’t says about installation.

    – Anu

    Comment by Anuradha — December 13, 2015 @ 11:20 pm

  3. Hi Anu- Thanks for pointing it out. I have updated jhelp with installation instructions.

    Comment by Jagjeet Singh — December 14, 2015 @ 12:28 pm

  4. What are the best terminal parameters to use this in putty or MobaTerm? i.e. number of rows and columns. Any particular font type or size?


    Comment by Mark — January 7, 2016 @ 1:17 am

  5. Hi Mark-

    I used putty with default font (Courier New) and default font size (10 or 11). Font should be fixed width and size you can adjust based on monitor size you are using. Any Terminal with 51 rows+ works perfectly fine. You can make font size bigger you are using a bigger monitor. Please refer jhelp for formatting. Arrary Size and GTOP(parameter) in sd.sql should be equal to terminal size (rows)

    Comment by Jagjeet Singh — January 7, 2016 @ 1:40 am

  6. Excellent. Thank you!

    Comment by Mark — January 7, 2016 @ 2:46 am

  7. Hi, when do you plan to release a stable 2.1 version of your amazing tool?

    Comment by Greg — September 2, 2016 @ 1:43 pm

  8. Hi Greg- I plan to finalize this soon with addition of DBIM metrics and a few others. But honestly, I haven’t come/across many issues and I think this is pretty stable at this point of time.

    Comment by Jagjeet Singh — September 3, 2016 @ 2:52 am

  9. super cool !! did you ever make just the load chart for one database?

    Comment by Kyle Hailey — September 23, 2016 @ 12:11 am

  10. Hi Kyle- do you mean only ASH chart for a single instance? This tool works with single instance if you have gv$view installed. I am under the impression that gv$* views are installed by default on 12c onwards. Please do let me know if that’s not what you are looking for.


    Comment by Jagjeet Singh — September 23, 2016 @ 8:07 am

  11. […] References: Load profile SQL Dashboard V2.1 (beta) […]

    Pingback by lprof | Zoltan Nyiri — March 15, 2017 @ 2:12 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:

WordPress.com Logo

You are commenting using your WordPress.com 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 WordPress.com.

%d bloggers like this: