RE: execution count of function in WHERE clause
Date: Thu, 3 Apr 2014 16:02:49 -0500
Message-ID: <C970F08BBE1E164AA8063E01502A71CF022AA625_at_WIN02.hotsos.com>
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-lReceived on Thu Apr 03 2014 - 23:02:49 CEST