ORACLE数据库监控系统计算QPS、TPS、CPS、RPS
发布时间：2023-02-17 09:21:44 所属栏目：Oracle 来源：互联网
导读：SELECT qps.device_id,qps.qps,cps.cps+rps.rps tps,cps.cps,rps.rps FROM (SELECT s1.device_id,s1.`NAME`,ROUND((s1.`value`-s2.`value`)/(15*60)) qps from sysstats s1,sysstats s2 WHERE s1.device_id=s2.device_id AND s1.`name`=s2.`name` and s1.`na
|
SELECT qps.device_id,qps.qps,cps.cps+rps.rps tps,cps.cps,rps.rps FROM (SELECT s1.device_id,s1.`NAME`,ROUND((s1.`value`-s2.`value`)/(15*60)) qps from sysstats s1,sysstats s2 WHERE s1.device_id=s2.device_id AND s1.`name`=s2.`name` and s1.`name`='execute count' AND s1.snap_id=(SELECT MAX(snap_id) FROM snaps WHERE donetime IS NOT NULL) AND s2.snap_id=(SELECT MAX(snap_id)-1 FROM snaps WHERE donetime IS NOT NULL)) qps JOIN (SELECT s1.device_id,ROUND((s1.`value`-s2.`value`)/(15*60)) cps from sysstats s1,sysstats s2 WHERE s1.device_id=s2.device_id AND s1.`name`=s2.`name` and s1.`name`='user commits' AND s1.snap_id=(SELECT MAX(snap_id) FROM snaps WHERE donetime IS NOT NULL) AND s2.snap_id=(SELECT MAX(snap_id)-1 FROM snaps WHERE donetime IS NOT NULL)) cps ON qps.device_id =cps.device_id JOIN (SELECT s1.device_id,ROUND((s1.`value`-s2.`value`)/(15*60)) rps from sysstats s1,sysstats s2 WHERE s1.device_id=s2.device_id AND s1.`name`=s2.`name` and s1.`name`='user rollbacks' AND s1.snap_id=(SELECT MAX(snap_id) FROM snaps WHERE donetime IS NOT NULL) AND s2.snap_id=(SELECT MAX(snap_id)-1 FROM snaps WHERE donetime IS NOT NULL)) rps ON qps.device_id =rps.device_id （编辑：甘南站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
