Toad World® Forums

Profiling an anonymous block

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