X-Git-Url: https://git.octo.it/?a=blobdiff_plain;f=contrib%2Foracle%2Fdb_systat.sql;h=cf2a3c4a58ce29088c5c4151b6df2d701e45f4f3;hb=25824c65721f0f21cadf1607fad367c7e7831816;hp=073c769628d64f85f7d6f02e8ee395e6a8f20c52;hpb=c87da66245197f489bb0e9efffc23538cf07e70b;p=collectd.git diff --git a/contrib/oracle/db_systat.sql b/contrib/oracle/db_systat.sql index 073c7696..cf2a3c4a 100644 --- a/contrib/oracle/db_systat.sql +++ b/contrib/oracle/db_systat.sql @@ -41,7 +41,7 @@ pga_hit_ratio FROM v$pgastat WHERE name = 'cache hit percentage'; --- DB Efficientcy +-- DB Efficiency SELECT ROUND(SUM(decode(metric_name, 'Database Wait Time Ratio', VALUE)), 2) AS database_wait_time_ratio, ROUND(SUM(decode(metric_name, 'Database CPU Time Ratio', VALUE)), 2) AS