autotrace under sql*plus

Hi,

When I tried the following under sql*plus, I got

SQL> set autot trace
ERROR:
ORA-24315: illegal attribute type


SP2-0619: Error while connecting
SP2-0611: Error enabling STATISTICS report
SQL>


How to fix this error?

Thanks,

have you run catxplan.sql?

Quote:

---

Originally posted by slimdave
have you run catxplan.sql?

---

for 9i this is not enougth.
U have to create plustrace role (as sys) and grant this role to user.

Code:

---

CONNECT / AS SYSDBA
@$ORACLE_HOME/SQLPLUS/ADMIN/PLUSTRCE.SQL
GRANT PLUSTRACE TO ....(user_name)...;

---

Quote:

---

Originally posted by slimdave
have you run catxplan.sql?

---

or may be utlxplan.sql :D