以 SYSDBA 登入執行以下腳本,授權給 PUBLIC(或特定用戶)。
SQL> CONN / AS SYSDBA SQL> @?/RDBMS/ADMIN/UTLXPLAN.SQL -- 建立 PLAN_TABLE SQL> CREATE PUBLIC SYNONYM PLAN_TABLE FOR PLAN_TABLE; SQL> GRANT ALL ON PLAN_TABLE TO PUBLIC; SQL> @?/SQLPLUS/ADMIN/PLUSTRCE.SQL -- 建立 PLUSTRACE 角色 SQL> DROP ROLE PLUSTRACE; -- 若已存在先刪 SQL> CREATE ROLE PLUSTRACE; 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 PUBLIC; -- 或特定用戶
SQL> SET AUTOTRACE ON SQL> SELECT * FROM EMP WHERE DEPTNO = 10; -- 輸出:Execution Plan + Statistics
PLAN_TABLE 版本不匹配:重跑 UTLXPLAN.SQL。V_$SESSTAT 權限:補 GRANT SELECT ON V_$SESSTAT TO PLUSTRACE。DBMS_XPLAN.DISPLAY_CURSOR 替代 AUTOTRACE,功能更強。