目前有一个求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);
标签:name,sysmetric,视图,oracle,id,select,con From: https://www.cnblogs.com/dbahrz/p/17117184.html