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
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.
Hi,
I have setup PL/SQL profiler for Toad. But how do i make it work? Is there a step by step setup. I went thru the Toad wizard it setup just fine. But when i use the toggle button on the top of the screen before starting/stopping an anonymous pl/sql block and refreshing the screen nothing shows up . Attached are the screen shots.
As far as I know, you can only profile database objects (procedures, functions, packages) not anonymous blocks.
Easiest workaround, especially since it looks like you are using your own database, is to create a procedure from your anonymous block and then run it with the "debug" button on the editor toolbar.
Then this dialog appears and you can click on the "Profiler" tab to enable/disable profiler.
-John
