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);
本文来自博客园,作者:蚌壳里夜有多长,转载请注明原文链接:https://www.cnblogs.com/dbahrz/p/17117184.html