tps

시간당 로그스위칭 횟수

select to_char(first_time,'yyyymmddhh24') ,count(*) from v$loghist

group by to_char(first_time,'yyyymmddhh24')

 

분당 commit,rollback 횟수

SELECT SUM(s.value/(86400*(SYSDATE - startup_time))) "tps" 

FROM V$SYSSTAT s, V$INSTANCE i 

WHERE s.NAME in ('user commits','transaction rollbacks')

tps가 0.18 나와요