Oracle-L: RE: monitor transactions over time

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Fri, 07 Mar 2003 19:14:25 -0800
Message-ID: <F001.00563E60.20030307191425@fatcity.com>

>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.

Kirti

-----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

Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !!

-----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 Fri Mar 07 2003 - 21:14:25 CST