Re: Extremly slow performance with Oracle and Linux

Gennaro,

thanks that helped very much. After I enabled autotrace I could see where the problem was. Just one more index an the execution time dropped from 2 minutes to 5 seconds.

Thanks

     Roger

Gennaro Napolitano <Gennaro.Napolitano_at_italdata.it> schrieb in im Newsbeitrag: 37CA85CA.93FED2DA_at_italdata.it...
> Hy Roger
>
> Before to set the autotrace option you need to run the 'utlxplan' sql
file,
> using SQL*Plus or svrmgrl, in order to create the statistic table
PLAN_TABLE.
>
> You can find this file under $ORACLE_HOME/rdbms80/admin (Windows NT).
>
> Hope this helps
>
> Ciao Gennaro
>
> Roger wrote:
>
> > Jill,
> >
> > I can't set the autotrace option. I get the following error message:
> >
> > Unable to verify PLAN_TABLE format or existence
> > Error enabling EXPLAIN report
> >
> > ???
> >
> > Regards
> > Roger
>
Received on Mon Aug 30 1999 - 09:25:50 CDT