查询V$SYSSTAT计算出QPS和TPS

QPS：前后两次差值/时间差

select  value from v$sysstat where name = 'execute count';
1
TPS：前后两次差值/时间差

select (select value   from v$sysstat  where name = 'user commits') + 
(select value   from v$sysstat  where name = 'user rollbacks') as TPS from dual;

 

其他v$sysstat指标
select trunc((sysdate-startup_time)) running_days from v$instance

select value from v$sysstat where name = 'enqueue deadlocks'

select value from v$sysstat  where name like  'logons current'