@?/rdbms/admin/utlxplan
create public synonym plan_table for plan_table;
grant all on plan_table to public;
@?/sqlplus/admin/plustrce.sql
grant plustrace to public;

#测试过程
connect /as sysdba;
select username,created from dba_users order by 2;
connect USERNAME/PASSWORD
set autotrace traceonly;

如果出现
SQL> set autotrace traceonly;
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
的提示,执行:
connect /as sysdba;
grant select any dictionary to public;

[@more@]

ITPub博客

oracle 9i 打开autotrace on

最新文章