| Execution Plan doubt [message #161118] |
Thu, 02 March 2006 01:28  |
frank.svs
Messages: 162
Registered: February 2006
|
Senior Member |
|
|
Hi all,
When i am saying set autotrace on it showing this error why.
SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
What is this SPn - errors codes.can anyone explain me.
My intention is to get the execution plan for my SQL statements.
For this what i've done.
As "sys" user,
SQL>@C:\software\oracle\ora92\sqlplus\admin\plustrce.sql
SQL>grant plustrace to scott;
Next i loggedin as scott user.
SQL>drop table plan_table;
@C:\software\oracle\ora92\rdbms\admin\utlxplan.sql
and now when saying set auotrace on it showing the below err
SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
