Re: execution count of function in WHERE clause

From: Sayan Malakshinov <>
Date: Thu, 3 Apr 2014 23:33:59 +0400
Message-ID: <>

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 <> 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

Received on Thu Apr 03 2014 - 21:33:59 CEST

Original text of this message