Re: Oracle hints
From: sybrandb <sybrandb_at_gmail.com>
Date: Wed, 30 Jan 2008 04:01:22 -0800 (PST)
Message-ID: <4821eba6-fe2e-4768-8cde-cdf910205835@q21g2000hsa.googlegroups.com>
Date: Wed, 30 Jan 2008 04:01:22 -0800 (PST)
Message-ID: <4821eba6-fe2e-4768-8cde-cdf910205835@q21g2000hsa.googlegroups.com>
On Jan 30, 11:43 am, Mladen Gogala <mgog..._at_yahoo.com> wrote:
> On Wed, 30 Jan 2008 01:10:42 -0800, sybrandb wrote:
> > Oracle is also merciless for people not using bind variables.
>
> No it isn't. CURSOR_SHARING=FORCE
>
> Oracle is merciful. Halelujah!
>
> --
> Mladen Gogalahttp://mgogala.freehostia.com
CURSOR_SHARING=FORCE is a KLUDGE
which can have very negative side effects.
consider the following statement
select substr(name, 1,10) from emp
/
becomes
select substr(name, :b1, :b2) from emp
/
Oracle can no longer determine the length of the resultstring. I know of at least one application which had problems because of this.
-- Sybrand Bakker Senior Oracle DBAReceived on Wed Jan 30 2008 - 06:01:22 CST