Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: TXNCOUNT in V$UNDOSTAT (9i R2) [ Was -- RE: monitor
Make that bug #2506744.....
Sorry..
-----Original Message-----
Sent: Thursday, March 13, 2003 7:20 PM
To: 'ORACLE-L_at_fatcity.com'
transactions over time ]
Today, Oracle Support updated my TAR, stating that there won't be a patch released to fix this bug (#2506774) in 9i R2.
Suggested workaround is to derive TXNCOUNT by subtracting the numbers from the previous sample period. And when you write one, watch out for those -ve numbers for TXNCOUNT.. :-))
Somebody is watching this list...... seriously.... ;) Rajendra, you need to put your script on e-bay ;)
Regards,
-----Original Message-----
Sent: Friday, March 07, 2003 9:14 PM
To: Multiple recipients of list ORACLE-L
>From what I know Oracle Development folks have identified the code changes to correct this problem. Just do not when Oracle would issue the patch. Since the bug was logged against 9i R2, patch would be provided.
This bug was originally logged in Aug 2002. There was no follow up.
The other issue with v$undostat view is that it does not work in Manual Undo Mode. Forget using it while in Manual Undo Management mode to monitor your undo usage to size undo tablespace accordingly. Forget what the documents, white papers say. Some of them are 'syntactically' correct in saying, "This view is available in Automatic and Manual Undo Management mode." Yes, that is true. The view is available in MUM mode. But, it returns one useless row in 9i R1 and nothing in 9i R2. I was told by Oracle Development that it did not work in 9i R1, in MUM mode, so they simply changed it to return nothing in 9i Rel 2. Hmmm... wonder if I followed this principle for some of the bugs in our Applications......... ;)
I will talk about this, and a few other things, in my Quick Tips Sessions, on AUM and FBQ, at the IOUG Conf next month.
-----Original Message-----
Sent: Friday, March 07, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L
I wrote a script to fix the problem in 9202, but don't tell Oracle ... we want them to fix the bug. as soon as they know there is a workaround, the priority on the bug will go down. Log a iTar and request a patch ... the bug# is 2506744
Raj
-----Original Message-----
Sent: Friday, March 07, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L
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: Deshpande, Kirti INET: kirti.deshpande_at_verizon.com 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 Thu Mar 13 2003 - 22:28:40 CST
![]() |
![]() |