Re: Viewing LCR Contents in Streams Capture Queues
- From: "Alex Fatkulin" <afatkulin@xxxxxxxxx>
- To: roman.podshivalov@xxxxxxxxx
- Date: Mon, 8 Dec 2008 16:35:40 -0500
This procedure print contents of the LCRs in the error queue so you
understand why the error has happened and how to fix it.
It doesn't work really well in case you have a lot of messages (since
it prints everything in the LCR, not only what causes an error) but
that's easily modifiable to avoid.
I don't think there is anything which can allow you to see in-flight
LCRs in the buffered queue so let me rewrite the question. Why do you
want to see these?
On Mon, Dec 8, 2008 at 3:41 PM, Roman Podshivalov
<roman.podshivalov@xxxxxxxxx> wrote:
> Hi,
>
> If you can get LCR from capture queue it can be printed out by using the
> procedure from 10G documentation. However I've never tried it personally.
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14229/strms_apmon.htm#CHDCBCIC
>
> --romas
>
> On Mon, Dec 8, 2008 at 3:05 PM, Stuart Blackburn <sblackbu@xxxxxxxxx> wrote:
>>
>> Does anyone know how to view the contents of an LCR that is currently
>> sitting in a Streams buffered capture queue?
>> DBMS_APPLY_ADM.GET_ERROR_MESSAGE is helpful for displaying the contents of
>> an LCR if it produces an apply error, but I can't find anything similar for
>> LCR's sitting in a buffered queue. Thanks.
>>
>> Stuart
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>
>
--
Alex Fatkulin,
http://www.linkedin.com/in/alexfatkulin
--
//www.freelists.org/webpage/oracle-l
Other related posts:
