List, Does anybody know a way to monitor the number of transactions occurring over time, say 5 minute or 10 minute intervals? I am looking at v$undostat and it appears to have a problem accumulating transactions under txncount when it should report over a 10 minute interval ( metalink doc# 260990.995, query v$undostat)
BEGIN_TIM END_TIME UNDOBLKS TXNCOUNT --------- --------- ---------- ---------- 05-MAR-03 05-MAR-03 38 161519 05-MAR-03 05-MAR-03 24 161468 05-MAR-03 05-MAR-03 1 161227 05-MAR-03 05-MAR-03 4 161075 05-MAR-03 05-MAR-03 71 160881 05-MAR-03 05-MAR-03 6932 160748 05-MAR-03 05-MAR-03 8 160073 05-MAR-03 05-MAR-03 14545 159887 05-MAR-03 05-MAR-03 19588 159010 05-MAR-03 05-MAR-03 2333 157084 05-MAR-03 05-MAR-03 6972 152649 the undo blocks appear correct, but transactions are accumulating. Does anybody know how to use v$transaction or another view to do this? This is 9iRel2 on Unix and the application is geared toward transaction processing. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
