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,
nam.name_ksrcdes
from
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
/
Regards
Jonathan Lewis
On Mon, 15 May 2023 at 02:13, Jack van Zanen <jack@xxxxxxxxxxxx> wrote:
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
