Re: Wait: Reliable message P1: Channel context

Is the time spent significant or is this just curiosity.

You've probably got all the information you need from the video that Stefan referenced, but if not I can add that I've seen this event creeping up the "Top 10" a couple of times, but I think it's always been a side effect of something much higher up the list.

One case was an application that kept dropping and creating tables (when it could have used GTTs or even WITH subqueries in most cases); the others were RAC systems where there was far too much chatter across the interconnect all the time, with hundreds or thousands of gc cr and gc cu requests and blocks hammering back and forth all the time. One of them was doing a huge number of direct path tablescans with a huge demand for undo blocks to get read-consistent results.

A query like the following will give you the channel name from the p1 value:

select

        ctx.waitcount_ksrcctx,
        ctx.waittime_ksrcctx,

        x$ksrcctx ctx,
        x$ksrcdes nam
where
        ctx.addr =  '000000008C4BA208'  -- your p1 left padded to 16
characters with 0
and     nam.indx = ctx.name_ksrcctx

> Hi All
>
>
> I am trying to find out what the wait
> Reliable message with P1 channel context is. I have tried google but no
> dice
> One of my sessions seem to encounter it a fair bit
>
> Oracle 12.2.01
>
>
> Thank you
>
> Jack van Zanen
>
>
> -------------------------
> This e-mail and any attachments may contain confidential material for the
> sole use of the intended recipient. If you are not the intended recipient,
> please be aware that any disclosure, copying, distribution or use of this
> e-mail or any attachment is prohibited. If you have received this e-mail in
> error, please contact the sender and delete all copies.
> Thank you for your cooperation
>

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