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.
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-lReceived on Thu Apr 03 2014 - 22:15:40 CEST