RE: execution count of function in WHERE clause

From: Ric Van Dyke <ric.van.dyke_at_hotsos.com>
Date: Thu, 3 Apr 2014 15:15:40 -0500
Message-ID: <C970F08BBE1E164AA8063E01502A71CF022AA619_at_WIN02.hotsos.com>

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:15:40 CEST