RE: Long Running Open Transaction

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
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 ?

Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
_at_jloracle



From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of April Sims [aprilcsims_at_gmail.com] Sent: 06 May 2015 16:29
To: ORACLE-L
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
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<mailto:aprilcsims_at_gmail.com>

--

http://www.freelists.org/webpage/oracle-l Received on Wed May 06 2015 - 18:15:17 CEST

Original text of this message