Re: Oracle Error

Thanks Martin.....it is a very good advice and I give it a try and let you know more about the updates...

Regards
Chewy

Martin Haltmayer wrote:

> 1. Set CURSOR_SPACE_FOR_TIME to false. It is a known bug that a setting of true
> gives you such errors, e. g. in the job queue processors.
>
> 2. Do a compute statistics, never an estimate. This is also a bug.
>
> 3. If you have lots of SQL with literals instead of bind variables, you may
> experience such behaviour as well.
>
> 4. Upgrade to 8.1.6 to get rid of those problems. It is a relief, really. Never
> saw such a smooth version. Do not forget to patch *after* the upgrade to 8.1.6.2
> to get rid of some wrong join results in the rule based optimizer. (If you
> upgrade before you will not be able to migrate your database.)
>
> Martin
>
> Alexander Chiu wrote:
> >
> > It is under oracle 8.1.5 and solaris 2.7
> >
> > Regards
> > Chewy
> >
> > Martin Haltmayer wrote:
> >
> > > What platform and what version of Oracle?
> > >
> > > Martin
Received on Mon Sep 11 2000 - 10:36:07 CDT