Re: Viewing LCR Contents in Streams Capture Queues
- From: "Roman Podshivalov" <roman.podshivalov@xxxxxxxxx>
- To: "Alex Fatkulin" <afatkulin@xxxxxxxxx>
- Date: Mon, 8 Dec 2008 16:54:28 -0500
As I see it, procedure print_lcr just prints any sys.anydata chunk assuming
it's LCR generated by streams capture. I responded to Stuart privately,
stating that - if there is a need to examine LCR in capture queue I don't
see why we cannot create custom subscriber to it with positive rule set to
filter all LCR of interest and in dequeue routine execute modified print_lcr
procedure to capture the output.
Also I wanted to second Alex's question - why do you want to see that ?
--romas
On Mon, Dec 8, 2008 at 4:35 PM, Alex Fatkulin <afatkulin@xxxxxxxxx> wrote:
> 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
>
Other related posts:
