-
in sqlplus i try set autotrace and send me the next message
SQL> set autotrace on
Cannot find the Session Identifier. Check PLUSTRACE role is enabled
Error enabling STATISTICS report
SQL>
what can i do?
-
you have to execute plustrce.sql and utlxplan.sql which creates a role called plustrace which is then granted to dba role so you need to be a user with dba role in order to execute auto trace otherwise grant plustrace role manually
utlxplan.sql will create plan_table... now this might be optional I cant remember since I always execute both
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
|