Yhere few things i obserwed:
1.Stats for “all runs” node in tree refreshes only when you click refresh and then change tab to Groups.
2.Profiler uses close_cached_open_cursors parmeter, obsolete from 8.x (see alert log afther executing profiler, with
close cached cursors parameter)
3.Wrong stats of execution, while first bind into shared pool. Execution parameters are extremly high, but seperate parameters for procedure and aonymous block are correct!
Watch attachement. This are two snapchots of one exeucution of procedure. Normally this procedure ends in about 1ms.
1.first flush shared pool : alter system flush_shared pool (Simulation of first execution of profiler)
2.Execute statement in profiler mode.
3. Watch reults…
correct.zip (115 KB)