Re: SQL*PLUS - SET AUTOTRACE ON problems

Yes, I did run the plustrce.sql script, and was able to grant plustrace to the SYSTEM user.

SET AUTOTRACE ON EXPLAIN works OK.

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

-Randy

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:r600jvckds6hvmu6jpduemhd1ll2c8agk0_at_4ax.com...
> On Tue, 05 Aug 2003 18:34:51 GMT, "Randy Nichols"
> <randynichols_at_yahoo.com> wrote:
>
> >As an inexperienced Oracle user, I am struggling with basic oracle
problems.
> >In trying to diagnose the problems, I run into more problems.
> >
> >Here I am trying to enable the SQL*PLUS autotrace in hopes of getting
some
> >information on my Advanced Queueing setup problems. But I cannot even
get
> >the autotrace working.
> >
> >I logged in as SYSTEM as SYSDBA and created the plustrace role. Then I
get
> >the following:
> >
> >---------------------------------
> >
> >SQL> grant plustrace to system;
> >
> >Grant succeeded.
> >
> >SQL> @e:\oracle9i\RDBMS/ADMIN/UTLXPLAN.SQL
> >
> >Table created.
> >
> >SQL> set autotrace on
> >ERROR:
> >ORA-24315: illegal attribute type
> >
> >
> >SP2-0619: Error while connecting
> >SP2-0611: Error enabling STATISTICS report
> >
> >--------------------------------------
> >
> >Can anyone shed some light on what is wrong here?
> >
> >Thanks,
> >
> >Randy Nichols
> >
>
> Did you run the plustrce.sql script (located in
> $ORACLE_HOME/sqlplus/adin, IIRC)
> The SP2 error messages seem to tell you didn't
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
>
Received on Tue Aug 05 2003 - 17:59:41 CDT