Sql Dashboard For RAC/Exadata - V2

It tells you info about Exadata smart scan/storage index saving/Flash cache/ CPU usage/TOP sqls/waits/Cluster interconnect traffic/Top segments by GC* waits and a lot more info. which can be useful to monitor system performance. Based on current formatting, It can support up to 8 node cluster information easily. I tried my best to make this utility lightweight by reading data from gv$ views once and store in plsql/collections for subsequent requests, Could not find session in EM top activity page running this utility. As of today, it will only work with 11g RAC instances or single instance with gv$* views [catclust.sql].

SQL> 
SQL> select * from table(jss.gtop);
SQL> 

From: http://jagjeet.wordpress.com/2012/09/20/sql-dashboard-v2/
From: http://jagjeet.wordpress.com/2012/05/13/sqlplus-dashboard-for-rac/