RE: execution count of function in WHERE clause
- From: Henry Poras <hrp@xxxxxxxxxx>
- To: Ric Van Dyke <ric.van.dyke@xxxxxxxxxx>
- Date: Thu, 3 Apr 2014 16:51:11 -0400
That would have been too easy. No SQL.
On Apr 3, 2014 4:15 PM, "Ric Van Dyke" <ric.van.dyke@xxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *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
>
Other related posts:
