Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> count PL/SQL function calls
I've a big SQL request (whith nested select) which use a PLS/SQL
function for filter.
SELECT
...
FROM
( SELECT ...
WHERE FIELD = myFunction(param1..)
)
WHERE ...
I want to count how many times myFunction is called.
How to do this ?
myFunction can't write in a table nether use a SEQUENCE or have an IN
OUT parameter. If it does SQL doesn't work.
Is there a tool ( a profiler) in TOAD to do that?
Thanks Received on Wed Aug 10 2005 - 06:01:08 CDT