Re: Oracle Error

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Mon, 11 Sep 2000 08:53:11 +0200
Message-ID: <39BC8157.9A0BF07D@0800-einwahl.de>

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.
Do a compute statistics, never an estimate. This is also a bug.
If you have lots of SQL with literals instead of bind variables, you may experience such behaviour as well.
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 - 01:53:11 CDT