Re: execution count of function in WHERE clause

  • From: Henry Poras <hrp@xxxxxxxxxx>
  • To: Carlos Sierra <carlos.sierra.usa@xxxxxxxxx>
  • Date: Thu, 3 Apr 2014 20:25:40 -0400

Thanks. I couldn't remember dbms_profiler and dbms_hprof. dbms_profiler did
the trick.

Henry


On Thu, Apr 3, 2014 at 5:38 PM, Carlos Sierra
<carlos.sierra.usa@xxxxxxxxx>wrote:

> You can also use SQLT XECUTE (215187.1)
>
>
> Cheers,
>
> Carlos Sierra
>
> blog: carlos-sierra.net
> twitter: @csierra_usa
>
> Life's Good!
>
> On Apr 3, 2014, at 3:25 PM, Henry Poras <hrp@xxxxxxxxxx> wrote:
>
> OK, I'm spacing on this one. I have an SQL statement with a function in
> the WHERE clause. Is there a way to see how many times it is being executed
> for each execution of the SQL? All I can think of/find is using a home made
> function with an internal counter. That won't help in this case.
>
> Thanks.
>
> Henry
>
>
>

Other related posts: