在SQL*PLUS中应用AUTOTRACE REPORT

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]  下一页

Copyright ＠ 2007-2012 敏韬网(敏而好学，文韬武略--MinTao.Net)（学习笔记） Inc All Rights Reserved.
闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)

鄂公网安备 42011102001154号

站长：MinTao ICP备案号：鄂ICP备11006601号-18