execution count of function in WHERE clause
From: Henry Poras <hrp_at_google.com>
Date: Thu, 3 Apr 2014 15:25:10 -0400
Message-ID: <CAAVg4uK2FYrTW85Gh0GLAF6avMQ1XULJ_z6rPfV5MNoVXBimZA_at_mail.gmail.com>
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.
Date: Thu, 3 Apr 2014 15:25:10 -0400
Message-ID: <CAAVg4uK2FYrTW85Gh0GLAF6avMQ1XULJ_z6rPfV5MNoVXBimZA_at_mail.gmail.com>
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 - 21:25:10 CEST