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