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.

About these ads

14 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: http://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


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 )

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

The Silver is the New Black Theme. Create a free website or blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 41 other followers

%d bloggers like this: