Re: Long Running Open Transaction

From: April Sims <aprilcsims_at_gmail.com>
Date: Wed, 6 May 2015 16:03:58 -0500
Message-ID: <CAK+cZDdLk-pny-ZUh1MEiSbKrUpqqTNoqmoG9BbgH_Cr=Hnbmg_at_mail.gmail.com>

Thanks for any replies on this...finally figured out the culprit.

April

On Wed, May 6, 2015 at 11:15 AM, Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk
> wrote:

>
> 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
>

-- 
April C. Sims
IOUG SELECT Journal Editor
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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 06 2015 - 23:03:58 CEST