Re: Problems whith PL/SQL and statistic

From: <bialik_at_wis.weizmann.ac.il>
Date: Thu, 16 Apr 1998 13:53:50 -0600
Message-ID: <6h5k3u$vm7$1@nnrp1.dejanews.com>

Hi.
It looks like you have a problem with Cost Based Optimizer. What version of Oracle are you using? ( CBO work with 7.3.x at least ).

Michael.
In article <3535ED86.1C2C6184_at_ing.unipi.it>, "Ing. Gabriele Cecchetti" <gabriele_at_ing.unipi.it> wrote:
>
> I'm a newbie with Oracle.
> I've an application bases on PL/SQL and C (on Alpha/OSF).
> This application runs fine.
> When I decided to run statistic with
> ANALYZE TABLE prova COMPUTE STATISTIC...
> I get:
> Table analized.
> Therefore app. does'nt work anymore and I get a lot of core dump.
> If I drop statistic, everithing works fine again.
>
> Anyone have any ideas about this problem.
>
> Cheers
> Gabriele
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 16 1998 - 14:53:50 CDT