Re: stored outlines and bind variables

From: Kerry Osborne <kerry.osborne_at_enkitec.com>
Date: Wed, 3 Feb 2010 08:37:27 -0600
Message-Id: <733EDA8E-9538-48FC-B179-310CEB263992_at_enkitec.com>

The answer is no (I'm pretty sure). Profiles have a way sharing across multiple statements that use literals (force_matching), but different variable names will be considered different statements.

Kerry Osborne
Enkitec
blog: kerryosborne.oracle-guy.com

On Feb 3, 2010, at 8:00 AM, hrishy wrote:

> Hi
>
> I have two sql statements like this
>
> 1)select ename from emp where empno :=b1
>
> 2)select ename from emp where empno := b2
>
> if i create a stored outline for the first will oracle use the
> stored outline for the second ?statement ?
>
> If not can i resort to using profiles can a single profile be used
> in this case for
>
> regards
>

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

Received on Wed Feb 03 2010 - 08:37:27 CST