oracle 19c 视图v$sysmetric 和视图v$con_sysmetric视图求出来数据有一些区别

目前有一个求oracle tps这么一个需求

19c要用这个统计tps

select ceil(a.value) from v$con_sysmetric a,v$container b where a.metric_name ='User Transaction Per Sec'
and a.con_id = b.con_id
and b.name = (select sys_context('userenv','con_name') con_name from dual);

如果要用视图v$sysmetric 脚本要改成

select ceil(max(a.value)) from v$con_sysmetric a,v$container b where a.metric_name ='User Transaction Per Sec'
and a.con_id = b.con_id
and b.name = (select sys_context('userenv','con_name') con_name from dual);

 

posted @ 2023-02-13 17:38  蚌壳里夜有多长  阅读(211)  评论(0编辑  收藏  举报