OraGlance lightweight Oracle SQL performance optimization monitoring software

OraGlance lightweight Oracle SQL performance optimization monitoring software is a lightweight graphical Oracle performance monitoring tool. Developed by Shitan Software, it is committed to providing a few simple and effective indicators to monitor Oracle databases without providing too many indicators.

Features of OraGlance, a lightweight Oracle SQL performance optimization monitoring software

It is green and non-implantable; you can run it directly with basically no preparation required.

There is no need to create any objects in the Oracle database, it only requires the following query permissions:

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;

If you want to run SQL Tuning Advisor, you need to grant dba permissions

Grant dba to pd1;

OraGlance lightweight Oracle SQL performance optimization monitoring software update log

​​ 1.Fix some bugs

​​ 2. Optimized some functions