-
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
-
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
-
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."
-
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
-
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
-
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
-
run utlxplan.sql from home/oracle/OraHome1/sqlplus/admin/utlxplan.sql
or find it in your system
saurabh
Saurabh Garg
OCP 9i
-
sorry from /home/oracle/OraHome1/rdbms/admin/utlxplan.sql
saurabh
Saurabh Garg
OCP 9i
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|