Long Running Open Transaction
From: April Sims <aprilcsims_at_gmail.com>
Date: Wed, 6 May 2015 10:29:05 -0500
Message-ID: <CAK+cZDc9rw-+0C7zTvt5iwin9sEgA4_RnxTupbLvCV1CQfvgwA_at_mail.gmail.com>
We have a transaction in v$transaction that appears to have been running since 4/29. It is hanging our logical standby apply process.
Date: Wed, 6 May 2015 10:29:05 -0500
Message-ID: <CAK+cZDc9rw-+0C7zTvt5iwin9sEgA4_RnxTupbLvCV1CQfvgwA_at_mail.gmail.com>
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_at_gmail.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed May 06 2015 - 17:29:05 CEST