Re: Oracle hints
Date: Wed, 30 Jan 2008 04:01:22 -0800 (PST)
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
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