Re: execution count of function in WHERE clause

From: Henry Poras <hrp_at_google.com>
Date: Thu, 3 Apr 2014 20:25:40 -0400
Message-ID: <CAAVg4uJUmnGZFvuO=kRfbErL2NjDzgJnbKaNLdrrRKBYo98TwQ_at_mail.gmail.com>

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_at_gmail.com>wrote:

> You can also use SQLT XECUTE (215187.1)
>
>
> Cheers,
>
> Carlos Sierra
>
> blog: carlos-sierra.net
> twitter: _at_csierra_usa
>
> Life's Good!
>
> On Apr 3, 2014, at 3:25 PM, Henry Poras <hrp_at_google.com> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 04 2014 - 02:25:40 CEST