Long Running Open Transaction

  • From: April Sims <aprilcsims@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 6 May 2015 10:29:05 -0500

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

Other related posts: