ORACLE 普通用户打开 AUTOTACE

1.创建数据库基础表plan_table(SYS用户）

    SQL>@?/rdbms/admin/utlxplan

    Tablecreated.

2.创建公共同义词

   SQL>create public synonym plan_table for plan_table;

    Synonym created.

3.将同义词赋权给所有用户

   SQL>grant all on plan_table to public;

   Grant succeeded.

4.创建角色

  SQL>@?/sqlplus/admin/plustrce.sql

  SQL> 
  SQL> drop role plustrace;
  drop role plustrace
          *
  ERROR at line 1:
  ORA-01919: role 'PLUSTRACE' does not exist
  SQL> create role plustrace;
  Role created.
  SQL> 
  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> 
  SQL> set echo off

5.授权角色

  SQL>grant plustrace to public;

  Grantsucceeded.