X-Git-Url: https://git.octo.it/?a=blobdiff_plain;f=contrib%2Foracle%2Fdb_systat.sql;h=cf2a3c4a58ce29088c5c4151b6df2d701e45f4f3;hb=1b10ab706f8b70ce2f086e59a54cc09d671ad989;hp=073c769628d64f85f7d6f02e8ee395e6a8f20c52;hpb=a3b477b60e7215ae813d665e22325b4b318646ef;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