autotrace under sql*plus
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: autotrace under sql*plus

  1. #1
    Join Date
    Jun 2000
    Posts
    295

    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,

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    have you run catxplan.sql?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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)...;

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by slimdave
    have you run catxplan.sql?
    or may be utlxplan.sql
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width