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.

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
Twitter, LinkedIn
Oracle Database 11g – Underground Advice for Database Administrators
OCP 8i, 9i, 10g, 11g DBA
Southern Utah University

Received on Wed May 06 2015 - 17:29:05 CEST

Original text of this message