RE: Long Running Open Transaction

From: Jonathan Lewis <>
Date: Wed, 6 May 2015 16:15:17 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D92828BB6A_at_EXMBX01.thus.corp>

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 ?

Jonathan Lewis

From: [] on behalf of April Sims [] Sent: 06 May 2015 16:29
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
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 - 18:15:17 CEST

Original text of this message