SQL*PLUS - SET AUTOTRACE ON problems

[Randy Nichols]

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

[Sybrand Bakker]

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

[Randy Nichols]

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" <gooid...@sybrandb.demon.nl> wrote in message
news:r600jvckds6hvmu6j...@4ax.com...

[Nuno Souto]

"Randy Nichols" <randyn...@yahoo.com> wrote in message news:<xFWXa.34835$Mc.27...@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
wizo...@yahoo.com.au.nospam

[Lucyna Witkowska]

Randy Nichols <randyn...@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:

You should login as SYS when you create the plustrace role.

Greetings,
LW

[Randy Nichols]

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" <wizo...@yahoo.com.au> wrote in message
news:73e20c6c.03080...@posting.google.com...

[Randy Nichols]

Perhaps that is the problem.

I've never been clear on the difference between "SYSTEM" and "SYS". Can you
point me to a good discussion or describe it?

-Randy Nichols

"Lucyna Witkowska" <ypwi...@nospamcyf-kr.edu.pl> wrote in message
news:bgqb3e$r1k$1...@srv.cyf-kr.edu.pl...

[Lucyna Witkowska]

Randy Nichols <randyn...@yahoo.com> wrote:
> Perhaps that is the problem.

> I've never been clear on the difference between "SYSTEM" and "SYS". Can you
> point me to a good discussion or describe it?

SYS is the owner of system objects (v_$session, ...).
SYSTEM can only access these objects.
So only SYS can grant object privileges like 'select on v_$session to
plustrace'.

Greetings,
LW