I think the event you want is 10270 and, from memory, the trace levels are a
bitmap so 1,2,4,8, etc. try 15 or 8191 for lots of information.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
@jloracle
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf
of Michael Cunningham [napacunningham@xxxxxxxxx]
Sent: 17 November 2015 17:14
To: oracle-l@freelists org
Subject: Low level tracing of a session during soft parse
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
