Re: execution count of function in WHERE clause
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Thu, 3 Apr 2014 23:33:59 +0400
Message-ID: <CAOVevU54ok8K=R79cF_WrRjZegpPOB-q0HFQ+Jy9Oyf2m2WZ9g_at_mail.gmail.com>
Hi Henry,
Date: Thu, 3 Apr 2014 23:33:59 +0400
Message-ID: <CAOVevU54ok8K=R79cF_WrRjZegpPOB-q0HFQ+Jy9Oyf2m2WZ9g_at_mail.gmail.com>
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_at_google.com> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 03 2014 - 21:33:59 CEST