oracle 9i 開啟autotrace on

@?/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@]