Re: Long Running Open Transaction

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 6 May 2015 10:38:46 -0500
Message-Id: <31F559F0-E18E-45A8-ADE9-9AAA70958A1C_at_gmail.com>

Is this a distributed transaction?

Sent from my iPhone

> On May 6, 2015, at 10:29 AM, April Sims <aprilcsims_at_gmail.com> wrote:
>
> 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
> 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-l

Received on Wed May 06 2015 - 17:38:46 CEST

This message: [ Message body ]
Next message: Chris Taylor: "Re: Moving self-contained /oracle filesystem to new server question"
Previous message: John Thomas: "Fwd: Real Application Testing (RAT) option"
In reply to: April Sims: "Long Running Open Transaction"
Next in thread: Jonathan Lewis: "RE: Long Running Open Transaction"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message