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 12c

grant 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.askmac.cn/OraGlance200701.zip

2020-07-08:

1. 现在oraglance支持最老的版本是11.2.0.1了 ，
2. 现在支持对top sql的历史执行情况查看了
3. 可以在查看SQL情况页面 调用sql tuning advisor 优化SQL语句 并给出建议了

build 2020-07-08:              https://zcdn.parnassusdata.com/OraGlance200708.zip