DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: SP2-0618 error

  1. #1
    Join Date
    Nov 2002
    Location
    INDIA
    Posts
    38

    SP2-0618 error

    I am getting the following error can anyone tell me the possible reason
    SQL> set autotrace on
    SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
    SP2-0611: Error enabling STATISTICS report

    Thanks and regards,

    Paddy

  2. #2
    Join Date
    Sep 2001
    Posts
    120
    you have to be grant PLUSTRACE role to yhe user from sys.
    oracle docs saye:
    To use this feature, you must have the PLUSTRACE role granted to you and a PLAN_TABLE table created in your schema

    saurabh
    Saurabh Garg
    OCP 9i

  3. #3
    Join Date
    Aug 2002
    Posts
    35

    Smile

    its becouse plan table is missing ...
    if the user executing this command is having DBA role then check if plan_table is existing or not else run utlxplan.sql script ..
    if user is not having dba role then u need to create pulstrace role and grant it to to the user for trunning explain plan
    "Be not afraid of growing slowly. Be afraid only of standing still."

  4. #4
    Join Date
    Nov 2002
    Location
    INDIA
    Posts
    38
    Thanks Saurabh,

    As you told I expected the same..hence I had tried but I got this..

    SQL> GRANT PLUSTRACE to scott;
    GRANT PLUSTRACE to scott
    *
    ERROR at line 1:
    ORA-01919: role 'PLUSTRACE' does not exist

    Thanks and regards,

    Paddy

  5. #5
    Join Date
    Sep 2001
    Posts
    120
    use this to create the role

    create role plustrace;

    grant select on v_$sesstat to plustrace;
    grant select on v_$statname to plustrace;
    grant select on v_$session to plustrace;
    grant plustrace to dba with admin option;



    or run this file as
    sqlplus "/ as sysdba" @/home/oracle/OraHome1/sqlplus/admin/plustrce.sql


    saurabh
    Saurabh Garg
    OCP 9i

  6. #6
    Join Date
    Nov 2002
    Location
    INDIA
    Posts
    38
    Thanks Saurabh,

    I did the following..all went fine..

    SQL> create role plustrace;

    Role created.

    SQL>
    SQL> grant select on v_$sesstat to plustrace;

    Grant succeeded.

    SQL> grant select on v_$statname to plustrace;

    Grant succeeded.

    SQL> grant select on v_$session to plustrace;

    Grant succeeded.

    SQL> grant plustrace to dba with admin option;

    Grant succeeded.

    Till the following happened...

    SQL> set autotrace on
    SP2-0613: Unable to verify PLAN_TABLE format or existence
    SP2-0611: Error enabling EXPLAIN reportSQL> set autotrace on

    Can you guide me through............

    Thanks in advance,

    Paddy

  7. #7
    Join Date
    Sep 2001
    Posts
    120
    run utlxplan.sql from home/oracle/OraHome1/sqlplus/admin/utlxplan.sql

    or find it in your system
    saurabh
    Saurabh Garg
    OCP 9i

  8. #8
    Join Date
    Sep 2001
    Posts
    120
    sorry from /home/oracle/OraHome1/rdbms/admin/utlxplan.sql

    saurabh
    Saurabh Garg
    OCP 9i

  9. #9
    Join Date
    Nov 2002
    Location
    INDIA
    Posts
    38
    Thanks Again Saurabh..

    I am through...Thanks to all who tried to help...

    Warm Regards,

    Paddy

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