SQL> set autotrace traceonly

SP2-0618: Cannot find the Session Identifier.  Check PLUSTRACE role is enabledSP2-0611: Error enabling STATISTICS reportSQL> conn / as sysdbaConnected.SQL> @$ORACLE_HOME/rdbms/admin/utlxplan

Table created.

SQL> create role plustrace;

Role created.

SQL> grant select on v_$sesstat to plustrace;

Grant succeeded.

SQL> grant select on v_$statname to plustrace;

Grant succeeded.

SQL> grant select on v_$mystat to plustrace;

Grant succeeded.

SQL> grant plustrace to dba with admin option;

Grant succeeded.

SQL> set echo off

SQL> grant plustrace to public;

Grant succeeded.

SQL> conn justin/justin

Error accessing PRODUCT_USER_PROFILEWarning:  Product user profile information not loaded!You may need to run PUPBLD.SQL as SYSTEMConnected.SQL> set autotrace traceonlySQL> set linesize 300 pagesize 300

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15480802/viewspace-706140/，如需转载，请注明出处，否则将追究法律责任。