設定autotrace全過程

SQL> conn
Connected.
SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report

SQL> conn
Connected.
SQL> @D:oracleora92rdbmsadminutlxplan.sql
SQL> create public synonym plan_table for plan_table;
SQL> grant all on plan_table to public;
SQL> conn as sysdba
Connected.
SQL> @D:oracleora92sqlplusadminplustrce.sql

SQL> grant plustrace to public;

Grant succeeded.

SQL>

SQL> conn
Connected.
SQL> set autotrace on statistics

[@more@]