Re: execution count of function in WHERE clause
- From: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
- To: hrp@xxxxxxxxxx
- Date: Thu, 3 Apr 2014 23:33:59 +0400
Hi Henry,
if this function is executing in one session only, you can get executions
from v$db_object_cache
On Thu, Apr 3, 2014 at 11:25 PM, Henry Poras <hrp@xxxxxxxxxx> wrote:
> 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
>
--
Best regards,
Sayan Malakshinov
Senior performance tuning engineer
PSBank
http://orasql.org
Other related posts:
