TRANSACTION PROCESSING RATE
--Description: Computer TP rate to get a better idea on sizing memory objects
SELECT SUM(s.value/(86400*(SYSDATE - TO_DATE(i.VALUE,'J')))) "tps"
FROM V$SYSSTAT s, V$INSTANCE i
WHERE s.NAME in ('user commits','transaction rollbacks') AND i.KEY = 'STARTUP TIME - JULIAN';
Discuss about Space management queries in breif you can reach out on 9966775883
--Description: Computer TP rate to get a better idea on sizing memory objects
SELECT SUM(s.value/(86400*(SYSDATE - TO_DATE(i.VALUE,'J')))) "tps"
FROM V$SYSSTAT s, V$INSTANCE i
WHERE s.NAME in ('user commits','transaction rollbacks') AND i.KEY = 'STARTUP TIME - JULIAN';
Discuss about Space management queries in breif you can reach out on 9966775883
No comments :
Post a Comment