Re: Oracle Streams is stuck.

Once in a while we had to set capture's_sga_size parameter to 2GB in order to pass past some of that long running stuff...otherwise it was terrible slow while mining from logs.

Try to increase _sga_size (that's memory available for logminer).

On 8/27/07, Arnon, Yuval <Yuval.Arnon_at_webloyalty.com> wrote:
>
>
>
>
> Hi,
>
> I've configured uni directional Streams on Win NT 32 bit, Oracle 10.2.0.3.
> Currently it was only streaming one schema with one table in it.
>
> The capture process was working fine for a few days.
>
> Today I am getting:
>
> C001: long running txn detected, xid: 0x000b.024.0085874b in the alert log,
> but can not find any long running transactions in our DB.
>
> In addition the capture process seems to be stuck at log mining one arch
> log. (I stopped and started the capture process to verify).
>
> I tried to use log miner to view contents of V$logmnr_contents, but the
> 'SELECT * FROM V$logmnr_contents' will not complete even I if let it run for
> 30 minutes.
>
>
>
> Any help will be appreciated.
>
>
>
> TIA
>
>
>
> Yuval
>
> This transmission may contain information that is privileged, confidential
> and exempt from disclosure under applicable law. If you,
> oracle-l_at_freelists.org, are not the intended recipient, you are hereby
> notified that any disclosure, copying, distribution, or use of the
> information contained herein (including any reliance thereon) is STRICTLY
> PROHIBITED. If you received this transmission in error, please immediately
> contact the sender and destroy the material in its entirety, whether in
> electronic or hard copy format. [neumann.webloyalty.com]

-- 
Alex Fatkulin,
The Pythian Group,
http://www.pythian.com/blogs/author/alexf/
--
http://www.freelists.org/webpage/oracle-l