There's a tracing event CURSORTRACE in Oracle since 10g - you can enable
the "cursor lookup & sharing" tracing for a specific hash value:
alter system set events 'immediate trace name cursortrace level 577,
address hash_value';
But there used to be some problems/bugs with disabling this once enabled,
so read this note (search for cursortrace) before proceeding:
*Troubleshooting: High Version Count Issues (Doc ID 296377.1)*
--
Tanel
http://blog.tanelpoder.com
On Tue, Nov 17, 2015 at 11:14 AM, Michael Cunningham <
napacunningham@xxxxxxxxx> wrote:
Hello all,
I have failed in my attempts so far, but what I'm trying to do is trace a
session during a soft parse where I will see in the trace that the child
cursor was found in the library cache and there is no need for a hard
parse. It's part of a research interest of mine.
I'm still searching for blogs that have done this already, but have not
found one yet.
I've tried strace with no success
I'm also looking for trace events (like 10046) that will trace this info.
So far:
10053 won't show anything because the child cursor already has an
execution plan
10046 level 12 does not show what I'm looking for
Any help is greatly appreciated.
--
Michael Cunningham
