OraGlance 轻量级的Oracle
SQL性能优化监控软件是一个轻量级的图形化Oracle性能监控工具。由诗檀软件开发,它致力于提供简单有效的几个指标来监控Oracle数据库,而不提供过多的指标。
OraGlance 轻量级的Oracle SQL性能优化监控软件个特色
它是绿色的,非植入式的;你可以直接运行它,而基本不需要做任何准备工作。
不需要在Oracle数据库内创建任何对象,其只需要以下几个查询权限:
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 轻量级的Oracle SQL性能优化监控软件更新日志
1.修复部分bug
2.优化了部分功能
华军小编推荐:
OraGlance 轻量级的Oracle SQL性能优化监控软件与Data Loader、Tarma QuickInstall、cc3d调参软件OpenPilot GCS等都是非常不错的软件,欢迎来我站下载体验!