Re: no cursor_sharing..

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 15 Jan 2001 13:16:56 -0000
Message-ID: <93ut8f$afn$1@soap.pipex.net>

Having reread your first post. have you bounced the database instance? Oracle won't age the statements out of the statement cache untill you do or shared pool is full).

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK
<oton66_at_my-deja.com> wrote in message news:93te36$6uc$1_at_nnrp1.deja.com...


> In article <93tdk9$6fm$1_at_nnrp1.deja.com>,

>   oton66_at_my-deja.com wrote:

> >  Martin Haltmayer wrote:

> > > Try "cursor_sharing = force".

> > >

> > > However, be warned. We found 8.1.6.2.1 on Solaris extremely instable

> > > with this setting. Dozens of ORA-00600 happening. If you can please

> > > use bind variables.

> >

> > Been trying different variations with case/spaces, also

> > alter system set cursor_sharing = force/FORCE

> > without luck, but anyways thanks for the warning.

> >

>


> Oops, a typo in my first posting.. cursor_sharing was always set

> to 'force', not 'TRUE'.

>


> -oton

>
>


> Sent via Deja.com

> http://www.deja.com/

Received on Mon Jan 15 2001 - 07:16:56 CST