Re: execution count of function in WHERE clause

From: Carlos Sierra <carlos.sierra.usa_at_gmail.com>
Date: Thu, 3 Apr 2014 17:38:09 -0400
Message-Id: <A5BE0E29-5446-4542-ABBC-B286E12F2536_at_gmail.com>

You can also use SQLT XECUTE (215187.1)

Cheers,

Carlos Sierra

blog: carlos-sierra.net
twitter: _at_csierra_usa

Life's Good!

On Apr 3, 2014, at 3: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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 03 2014 - 23:38:09 CEST

This message: [ Message body ]
Next message: Carlos Sierra: "Re: execution count of function in WHERE clause"
Previous message: Bheemsen Aitha: "RE: Create table performance in 11gR2"
In reply to: Henry Poras: "execution count of function in WHERE clause"
Next in thread: Henry Poras: "Re: execution count of function in WHERE clause"
Reply: Henry Poras: "Re: execution count of function in WHERE clause"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message