Re: Long Running Open Transaction

From: Gus Spier <gus.spier_at_gmail.com>
Date: Wed, 6 May 2015 18:52:31 -0400
Message-ID: <CAG8xnidvCVt-=sLmcaiEKgL9qnjX1+tetXdnVy6x9z8p_2i82Q_at_mail.gmail.com>

Oh, April! That's not fair! What did you have to do?

Friendly regards,

Gus

On Wed, May 6, 2015 at 5:03 PM, April Sims <aprilcsims_at_gmail.com> wrote:

> 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 Thu May 07 2015 - 00:52:31 CEST