Oracle - SQL 优化 -------- > 创建PLUSTRACE角色

来源：互联网发布：安易数据恢复免费版编辑：程序博客网时间：2024/06/06 09:55

SQL> conn / as sysdbaConnected.SQL> @$ORACLE_HOME/sqlplus/admin/plustrce

运行结果：

SQL> SQL> drop role plustrace;drop role plustrace          *ERROR at line 1:ORA-01919: role 'PLUSTRACE' does not existElapsed: 00:00:01.71SQL> create role plustrace;Role created.Elapsed: 00:00:00.26SQL> SQL> grant select on v_$sesstat to plustrace;Grant succeeded.Elapsed: 00:00:00.27SQL> grant select on v_$statname to plustrace;Grant succeeded.Elapsed: 00:00:00.02SQL> grant select on v_$mystat to plustrace;Grant succeeded.Elapsed: 00:00:00.02SQL> grant plustrace to dba with admin option;Grant succeeded.Elapsed: 00:00:00.02SQL> SQL> set echo off

执行完该脚本，就可以在数据库中看到一个名为PLUSTRACE的角色，而且可以将该角色授权给需要使用SET AUTOTRACE的用户。

## 给用户scott授权

SQL> grant plustrace to scott;Grant succeeded.Elapsed: 00:00:00.03

## 看下，是否可以使用了？

SQL> set autotrace onSQL> select 1 from dual;         1----------         1Elapsed: 00:00:00.06Execution Plan----------------------------------------------------------   0      SELECT STATEMENT Optimizer=CHOOSE   1    0   TABLE ACCESS (FULL) OF 'DUAL'Statistics----------------------------------------------------------          0  recursive calls          0  db block gets          0  consistent gets          0  physical reads          0  redo size          0  bytes sent via SQL*Net to client          0  bytes received via SQL*Net from client          0  SQL*Net roundtrips to/from client          0  sorts (memory)          0  sorts (disk)          1  rows processed

OK !