RE: Interpreting USED_UREC from V$TRANSACTION

From: Herring Dave - dherri <Dave.Herring_at_acxiom.com>
Date: Fri, 6 Jul 2012 18:33:35 +0000
Message-ID: <BD475CE0B3EE894DA0CAB36CE2F7DEB4CE809634_at_CWYIGMBCRP02.Corp.Acxiom.net>



Allen, unfortunately the script I've been using doesn't include USED_UBLK. Good thought though. Also, I had seen Tom Kyte's discussion earlier and hoped it'd apply but unfortunately doesn't.

BTW, I think it's pretty cool that people on this list will do searches on their own to help out others. It's generally assumed that we've done a search or 2 ahead of time before asking a question, maybe even read Oracle's doc, but a different person's search attempt is always helpful (and welcomed!).

DAVID HERRING
DBA
Acxiom Corporation

EML   dave.herring_at_acxiom.com
TEL    630.944.4762
MBL   630.430.5988 

1501 Opus Pl, Downers Grove, IL 60515, USA WWW.ACXIOM.COM
-----Original Message-----

From: Allen, Brandon [mailto:Brandon.Allen_at_OneNeck.com] Sent: Friday, July 06, 2012 12:55 PM
To: Herring Dave - dherri; Oracle-L (oracle-l_at_freelists.org) Subject: RE: Interpreting USED_UREC from V$TRANSACTION

I don't know the answer, but I'm curious if you see the same behavior with used_ublk? I've always used used_ublk instead of used_urec for tracking rollback progress, but I'm not really sure if one is more reliable than the other. I found a mention of negative values from Tom Kyte here, but it's not very helpful for your situation:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:7143624535091#7144052065612


Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.



The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.

If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.

If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.

Thank You.


--

http://www.freelists.org/webpage/oracle-l Received on Fri Jul 06 2012 - 13:33:35 CDT

Original text of this message