It would probably have been a good idea to include the URL in the previous
email: Line Numbers | Oracle Scratchpad (wordpress.com)
<https://jonathanlewis.wordpress.com/2014/11/28/line-numbers/>
Regards
Jonathan Lewis
On Fri, 4 Aug 2023 at 16:06, Jonathan Lewis <jlewisoracle@xxxxxxxxx> wrote:
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@xxxxxxxxxxxxxxx> 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)
