I think I registered this question once, but I cannot find it now so I'll do it again.
I have a 10046 trace with a statement executed twice in the same session (same bind values) . I have different plans for each execution
When formatting the sql is showed once.
I wonder if I can make tkprof list each single execution individually, I checked the aggregate function but if I understand it
correct it only divides sql based on users.
Anyone who knows a tool that can do what I want or if I can do this with tkprof.
Version is 11.2.0.3
Appreciate your feedback.
Thanks
Magnus