Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen Revision Vorhergehende Überarbeitung Nächste Überarbeitung | Vorhergehende Überarbeitung | ||
software:dashboard:analyses:instance_analyses_oracle [2016/09/22 14:42] martin.oehm |
software:dashboard:analyses:instance_analyses_oracle [2021/07/01 09:52] (aktuell) |
||
---|---|---|---|
Zeile 3: | Zeile 3: | ||
<code sql> | <code sql> | ||
SELECT | SELECT | ||
- | concat(to_char(inst.creationtime,'yy'), concat(to_char(inst.creationtime,'mm'), to_char(inst.creationtime,'dd'))) AS Tag, SUM(1) as Count | + | concat(to_char(inst.creationtime,'yy'), concat(to_char(inst.creationtime,'mm'), to_char(inst.creationtime,'dd'))) AS Tag, SUM(1) as Anzahl |
FROM view_instance inst | FROM view_instance inst | ||
group by concat(to_char(inst.creationtime,'yy'), concat(to_char(inst.creationtime,'mm'), to_char(inst.creationtime,'dd'))) | group by concat(to_char(inst.creationtime,'yy'), concat(to_char(inst.creationtime,'mm'), to_char(inst.creationtime,'dd'))) | ||
Zeile 11: | Zeile 11: | ||
<code sql> | <code sql> | ||
SELECT | SELECT | ||
- | concat(to_char(inst.creationtime,'yy'), to_char(inst.creationtime,'mm')) AS Monat, ROUND(SUM(1)/22,1) as "Average per day" | + | concat(to_char(inst.creationtime,'yy'), to_char(inst.creationtime,'mm')) AS Monat, ROUND(SUM(1)/22,1) as "Durchschnitt pro Tag" |
FROM view_instance inst | FROM view_instance inst | ||
group by concat(to_char(inst.creationtime,'yy'), to_char(inst.creationtime,'mm')) | group by concat(to_char(inst.creationtime,'yy'), to_char(inst.creationtime,'mm')) |