monitor transactions over time

From: Ehresmann, David <David.Ehresmann_at_ps.net>
Date: Fri, 07 Mar 2003 14:03:49 -0800
Message-ID: <F001.00563CC2.20030307140349@fatcity.com>

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: David.Ehresmann_at_ps.net

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: ListGuru_at_fatcity.com (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). Received on Fri Mar 07 2003 - 16:03:49 CST