Jagjeet's Oracle Blog!

December 20, 2013

SQL Dashboard – V2

Filed under: Exadata, RAC — Jagjeet Singh @ 12:58 am

Quick Post – I had some fun last weekend with SQL Dashboard, thought it deserves a post. As you can see in attached video now dashboard supports wait graph in colors directly from SQL*Plus  🙂  wait a minute

Well, we all know sql*plus does not support colors, However, I could simulate that using Iterm2 (Mac terminal client) by assigning colors to specific legends.

I have received several emails to make code compatible with 10g, unfortunately it is not possible due to dependency on 11g dictionaries. I have fixed several bugs and publishing 11g R2 and 11g R1 version.

Only noticeable enhancement is graph with wait events.

17 Comments »

  1. […] Singh mentioned that he has built a V2 of his cool SQL Dashboard sqlplus-based monitoring script, which now also shows a nice colored ASH graph output. Yes, right […]

    Pingback by Sqlplus is my second home: Part 6 – Colorizing sqlplus and terminal output | Tanel Poder's blog: IT & Mobile for Geeks and Pros — September 20, 2012 @ 4:10 am

  2. Colorful now – Great!

    Comment by Rahul Batta — September 20, 2012 @ 6:29 am

  3. […] Fully graphic Dashboard using SQL*Plus?! […]

    Pingback by State of Data #120 « Dr Data's Blog — October 13, 2012 @ 5:34 am

  4. cool

    Comment by bitizerg — October 24, 2012 @ 11:20 am

  5. only see black in video … but can hear sound … can see static graphics at beginning/end of video …

    Comment by Mike Kemp — November 28, 2012 @ 4:25 am

  6. Mike-

    For me, video is working fine, could you check direct link ..

    Comment by Jagjeet Singh — November 28, 2012 @ 5:40 pm

  7. Everything works now. Sorry for false alarm, must have been intermittent issue with my machine. Who knows. Thank you for taking time to respond.

    Comment by Mike Kemp — November 28, 2012 @ 9:15 pm

  8. […] this looks quite cool: https://jagjeet.wordpress.com/2012/09/20/sql-dashboard-v2/ […]

    Pingback by Kyle Hailey » Best Oracle Performance Tools — September 13, 2013 @ 7:38 pm

  9. Thanks for providing for oracle solutions

    Comment by eva lona — October 7, 2013 @ 6:45 pm

  10. does anyone know if there is an SSH tool for windows that will let me assign colors like iterm on the mac?

    Comment by Ryan — October 11, 2013 @ 12:05 am

  11. can u have script for a single instance database….(dashboard)….it will be immense help to me

    Comment by kshitiz — July 25, 2014 @ 5:46 pm

  12. Sql Dashboard can also be used for single instance if GV$ views are installed. Can be installed by running catclustdb.sql on single instance.

    Comment by Jagjeet Singh — July 25, 2014 @ 10:40 pm

  13. best phoenix criminal defense lawyer

    SQL Dashboard – V2 | Jagjeet’s Oracle Blog!

    Trackback by best phoenix criminal defense lawyer — September 18, 2014 @ 3:11 pm

  14. Hi,

    I am trying to run your tool but output seems all messed up…

    is there a setting that i need to set from SQLPLUS standpoint to get output like you have in the video?

    i tried different line size and that didnt helped either…

    Comment by Max Scalf — November 19, 2014 @ 10:29 pm

  15. Hi Max-

    Yes, there is setting. I apologies for not giving clear information here.

    1- you can download the latest one which I haven’t blogged as still working for some corner cases.

    https://dl.dropboxusercontent.com/u/40978963/V2.1.zip

    in above zip, there is file named jhelp which tells example how to set various parameters. In nut-shell you have to set the *arraysize* at sql prompt equal to what value we pass to package.

    See below example – you can see “50” as number of lines were passed. reduce or increase based on your resolution.

    ## With All Defaults Values — Sample=6 Secs , Colors=Background Color, Default 3 Sysmetrics
    ~~~~~~~~~
    SET LINESIZE 5000 pagesize 0 Arraysize 50 TAB OFF
    SELECT * FROM TABLE(JSS.GTOP(50));
    ~~~~~~~~~

    If you need further information/help, please reach out to me on jagjeet.malhi@gmail.com. Would be happy to work with you.

    thanks

    Comment by Jagjeet Singh (@Jagjeets) — November 19, 2014 @ 11:17 pm

  17. […] Sites Trusted Steroid Sites Trusted Steroid Sites Trusted Steroid Sites Trusted Steroid Sites Trusted Steroid Sites Trusted Steroid Sites Trusted Steroid Sites Trusted Steroid Sites Trusted Steroid Sites Trusted […]

    Pingback by real steroids suppliers — June 11, 2017 @ 1:31 pm


RSS feed for comments on this post. TrackBack URI

Leave a comment

Blog at WordPress.com.