Thanks for any replies on this...finally figured out the culprit.
April
On Wed, May 6, 2015 at 11:15 AM, Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx
wrote:
Is the used_ublk / used_urec going up, coming down, or staying the same ?
What's the value of used_urec ?
Does the session still exist - what is it's value of last_call_et ?
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
@jloracle
------------------------------
*From:* oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on
behalf of April Sims [aprilcsims@xxxxxxxxx]
*Sent:* 06 May 2015 16:29
*To:* ORACLE-L
*Subject:* Long Running Open Transaction
We have a transaction in v$transaction that appears to have been
running since 4/29. It is hanging our logical standby apply process.
How does one resolve this in a NON-STREAMS environment?
I used the code in MOS doc
How to gather info about uncommitted transactions (Doc ID 786472.1)
that gives a test case but no information on how to proceed from there?
--
April C. Sims
http://aprilcsims.wordpress.com
Twitter, LinkedIn
Oracle Database 11g – Underground Advice for Database Administrators
<http://www.amazon.com/Oracle-Database-Underground-Advice-Administrators/dp/1849680000/ref=sr_1_1?ie=UTF8&s=books&qid=1272289339&sr=8-1#noop>
https://www.packtpub.com/oracle-11g-database-implementations-guide/book
OCP 8i, 9i, 10g, 11g DBA
Southern Utah University
aprilcsims@xxxxxxxxx