Re: Low level tracing of a session during soft parse

From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Tue, 17 Nov 2015 12:33:35 -0600
Message-ID: <CAMHX9JKKmMKmjgeXy1=DKN6ru8c0EzLW0UZ4rWPHAAG_wz8BiQ_at_mail.gmail.com>

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_at_gmail.com> 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

>


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

Received on Tue Nov 17 2015 - 19:33:35 CET