Re: SQL*PLUS - SET AUTOTRACE ON problems

The plan table was freshly created just before setting autotrace by running that script. Is it possible there is some configuration parameter that needs to be set somewhere?

-Randy

"Nuno Souto" <wizofoz2k_at_yahoo.com.au> wrote in message news:73e20c6c.0308051835.74bd124b_at_posting.google.com...
> "Randy Nichols" <randynichols_at_yahoo.com> wrote in message
news:<xFWXa.34835$Mc.2764615_at_newsread1.prod.itd.earthlink.net>...
> > It seems to be the
> >
> > SET AUTOTRACE ON STATISTICS
> >
> > that has a problem, giving error:
> >
> > SQL> set autotrace on statistics
> > ERROR:
> > ORA-24315: illegal attribute type
> >
> >
> > SP2-0619: Error while connecting
> > SP2-0611: Error enabling STATISTICS report
> >
>
> wild guess, but I'd say your PLAN_TABLE
> is of a different version than what you running now.
> In $ORACLE_HOME/rdbms/admin (%ORACLE_HOME%\RDBMS\ADMIN
> if you wash windows), there is a file called UTLXPLAN.sql
> Run that script logged on as that user and see if it fixes the
> prob.
>
> Cheers
> Nuno Souto
> wizofoz2k_at_yahoo.com.au.nospam
>
Received on Wed Aug 06 2003 - 10:13:07 CDT