Profiling an anonymous block

crjohnso · April 21, 2016, 11:39pm

Can PLSQL Profiler profile an anonymous block? I have a very simple anonymous block procedure that runs an absurd amount of time and I’m trying to understand why. I clicked on PLSQL profiler, ran the script, turned profile off, but (apparently) nothing is being captured.

Does it have to be a stored procedure to work?

Chris Johnson

IT Systems Analyst

Distribution Logistics

615-855-4371

Gary.Jerep · June 13, 2016, 4:23pm

Should be able to profile anonymous blocks just fine... default in the latest Toad versions is to not show anon blocks and only show executed lines but you can toggle these on/off.

Simply right-click on the Profiler Analysis display tree and toggle on "Show Anonymous Blocks", per screen snap below.