Re: execution count of function in WHERE clause

From: Carlos Sierra <carlos.sierra.usa_at_gmail.com>
Date: Thu, 3 Apr 2014 17:37:31 -0400
Message-Id: <0D13BBEC-CBB0-43D3-8995-C2B9FB889CF1_at_gmail.com>

If you get to use PL/SQL Profiler, script attached produces a nice clean HTML report out of the data collected by it

Cheers,

Carlos Sierra

blog: carlos-sierra.net
twitter: _at_csierra_usa

Life's Good!

On Apr 3, 2014, at 5:02 PM, Ric Van Dyke <ric.van.dyke_at_hotsos.com> wrote:

> Of course…. Well you could use DBMS_PROFILER or DBMS_HPROF which are the built in PL/SQL profiler packages. There is a bit to using them but they might show you what you need. Also there is DBMS_TRACE which might be good, it doesn’t have any timing info but does show counts.
>
> - Ric
>
> From: Henry Poras [mailto:hrp_at_google.com]
> Sent: Thursday, April 03, 2014 4:51 PM
> To: Ric Van Dyke
> Cc: ORACLE-L
> Subject: RE: execution count of function in WHERE clause
>
> 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 - 23:37:31 CEST