Re: Low level tracing of a session during soft parse

I could not get any information from 10270 trace while simply executing the sql statement wither during a hard parse or soft parse.

From the Doc ID 296377.1

alter system set events 'immediate trace name cursortrace level 577, address <hash_value>';
(levels 578-580 can be used for high level tracing (577=level 1, 578=level 2, 580=level 3)

• this turns off tracing alter system set events 'immediate trace name cursortrace level 2147483648, address 1';

Turning off cursortrace worked for me on: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

Thanks for the help,
Michael

On Tue, Nov 17, 2015 at 11:19 AM, Michael Cunningham < napacunningham_at_gmail.com> wrote:

> Thank you gentlemen, I will look at both of these today.
>
> On Tue, Nov 17, 2015 at 10:21 AM, Jonathan Lewis <
> jonathan_at_jlcomp.demon.co.uk> wrote:
>
>>
>>
>> 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
>> _at_jloracle
>> ------------------------------
>> *From:* oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on
>> behalf of Michael Cunningham [napacunningham_at_gmail.com]
>> *Sent:* 17 November 2015 17:14
>> *To:* oracle-l_at_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
>>
>
>
>
> --
> Michael Cunningham
>

-- 
Michael Cunningham

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