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>

SQL> grant select on v_$session to plustrace;

Grant succeeded.

SQL> grant plustrace to dba with admin option;

Grant succeeded.

SQL>

SQL> set echo off

（注：赋角色plustrace给所需用户，这里用户是bill）

SQL> grant plustrace to bill;

Grant succeeded.

（注：接下来，用bill用户连接，测试AUTOTRACE）

SQL> connect bill/bill’s password;

Connected.

SQL> show user

USER is "BILL"

(注：为了看的清楚些，建立一个测试的表test，然后察看AUTOTRACE报告)

SQL>  create table test(id number(1));

Table created.

SQL> insert into test values(1);

1 row created.

SQL> /

1 row created.

SQL> /

1 row created.

SQL> /

1 row created.

SQL> commit;

Commit complete.

SQL> select * from test;

        ID

----------

         1

         1

         1

         1

SQL> set AUTOTRACE on

SQL> select * from test;

        ID

----------

  &nbs

上一页  [1] [2] [3] [4]  下一页