Re: Tracing query inside procedure without 10046

David,

Coincidentally I rediscovered this blog note a few minutes ago - which may be the problem I was thinking of, and may not be the same problem to the hierarchical profiler. I've just tested on 23c and I changing the plsql_optimize_level changes the line number reported by the call to calculate ln(-1), and the default setting is the one where the reported line number doesn't match user_source.

Regards
Jonathan Lewis

On Fri, 4 Aug 2023 at 14:15, David Kurtz <info_at_go-faster.co.uk> wrote:

> I haven't observed that, but I have only used the hierarchical profiler in
> 19c. It has always matched up for me.
>
> And, of course, you wave to unwrap and save procedures to see them in
> user_source. Doing so doesn't seem to affect the line numbers.
>
>
>
> David Kurtz
> Go-Faster Consultancy
> www.go-faster.co.uk
> Tel: +44 7771 760660
> (sent from a mobile device, typos and brevity to be expected)
>
>>
>>>>>

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