OraGlance是一个轻量级的图形化Oracle性能监控工具。由诗檀软件开发，它致力于提供简单有效的几个指标来监控Oracle数据库，而不提供过多的指标。它是绿色的，非植入式的；你可以直接运行它，而基本不需要做任何准备工作。 不需要在Oracle数据库内创建任何对象，其只需要以下几个查询权限:OraGlance is a lightweight oracle performance monitor tool , developed by parnassusdata.com . It will only focus on most important metric .you can easily run it without any prerequisite. It will ask for below permission:supports oracle version: 11gR2 12cgrant create session to pd1;
grant select on gv_$active_session_history to pd1;
grant select on gv_$SQL to pd1;
grant select on gv_$SQL_MONITOR to pd1;
grant select on gv_$SQLSTATS to pd1;
grant select on v_$database to pd1;
grant select on gv_$instance to pd1;
grant select on gv_$statname to pd1;
grant select on gv_$sysstat to pd1;
grant select on gv_$osstat to pd1;
grant select on gv_$dlm_misc to pd1;
grant select on gv_$session_blockers to pd1;
grant select on dba_hist_sqltext to pd1;
grant select on dba_hist_sqlstat to pd1;
grant select on dba_hist_snapshot to pd1;
grant select on dba_advisor_sqlstats to pd1;
grant select on dba_sqlset_statements to pd1;
如果要运行SQL Tuning Advisor 则需要授予dba权限
grant dba to pd1;
OraGlance是免费的，你可以安心使用它。OraGlance is free software , use it as you like.下载地址Download URL ： https://zcdn.parnassusdata.com/OraGlance200708.zip update log:适配了12c，增加了登录界面保存，增加了托盘功能，优化了界面， 为sqlite中的表增加了索引。 build 2020-07-01 : https://zcdn.askmaclean.com/OraGlance200701.zip 2020-07-08:现在oraglance支持最老的版本是11.2.0.1了 ，现在支持对top sql的历史执行情况查看了可以在查看SQL情况页面 调用sql tuning advisor 优化SQL语句 并给出建议了build 2020-07-08: https://zcdn.parnassusdata.com/OraGlance200708.zip
