Shulou(Shulou.com)05/31 Report--

This article mainly introduces the database startup implementation plan report SP2-0618\ SP2-0611 error how to do, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, let the editor take you to know about it.

Question:

SQL > set autotrace on traceonly explain

SP2-0618: the session identifier cannot be found. Enable inspection of PLUSTRACE roles

SP2-0611: error enabling STATISTICS reporting

Solution:

1. Execute the following script

SQL > @ / u01/app/oracle/product/11.2.0.4/db_1/sqlplus/admin/plustrce.sql

2. Delete the existing plustrace role

SQL > drop role plustrace

3. Recreate the plustrace role

SQL > create role plustrace

4. Authorization of roles

SQL > grant select on v_$sesstat to plustrace

SQL > grant select on v_$statname to plustrace

SQL > grant select on v_$mystat to plustrace

SQL > grant plustrace to dba with admin option

Grant plustrace to public

5. Open it again successfully

SQL > set autotrace on

SQL >

Thank you for reading this article carefully. I hope the article "how to start the execution Plan in the Database SP2-0618\ SP2-0611 error" shared by the editor will be helpful to everyone. At the same time, I hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.