RE: execution count of function in WHERE clause

From: Henry Poras <hrp_at_google.com>
Date: Thu, 3 Apr 2014 16:51:11 -0400
Message-ID: <CAAVg4u+n50Bq+prMA9W4FEL7biuqHgWV8wT2x9oDpWZ_ADqsuw_at_mail.gmail.com>

That would have been too easy. No SQL.
On Apr 3, 2014 4:15 PM, "Ric Van Dyke" <ric.van.dyke_at_hotsos.com> wrote:

> What does the function do? If it does some SQL, the good old 10046
> tracing will show each time it’s called and how much work it did each
> time. Then you should use the Hotsos Profiler, of course J, to see a
> nice roll up of what happened.
>
>
>
> - Ric
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Henry Poras
> *Sent:* Thursday, April 03, 2014 3:25 PM
> *To:* ORACLE-L
> *Subject:* execution count of function in WHERE clause
>
>
>
> 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 Thu Apr 03 2014 - 22:51:11 CEST