ITPub博客

首页 > 数据库 > Oracle > set autotrace on [configure]

set autotrace on [configure]

原创 Oracle 作者:tolilong 时间:2015-10-03 10:57:14 0 删除 编辑

SQL> conn /as sysdba
Connected.
SQL> @?/rdbms/admin/utlxplan.sql

Table created.

SQL> @?/sqlplus/admin/plustrce.sql
SQL>
SQL> drop role plustrace;

Role dropped.

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
SQL>
SQL>
SQL> conn scott/bruce123
Connected.
SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier.  Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
SQL> conn / as sysdba
Connected.
SQL> grant plustrace to scott;

Grant succeeded.

SQL> conn scott/bruce123
Connected.
SQL> set autotrace on
SQL>

SQL> select max(id) from tt6;

   MAX(ID)
----------
  10053197


Execution Plan
----------------------------------------------------------
Plan hash value: 2149112514

-------------------------------------------------------------------------------------
| Id  | Operation                  | Name   | Rows  | Bytes | Cost (%CPU)| Time     |
-------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT           |        |     1 |    13 |   185   (4)| 00:00:03 |
|   1 |  SORT AGGREGATE            |        |     1 |    13 |            |          |
|   2 |   INDEX FULL SCAN (MIN/MAX)| TT6_PK |   197K|  2503K|            |          |
-------------------------------------------------------------------------------------

Note
-----
   - dynamic sampling used for this statement


Statistics
----------------------------------------------------------
          4  recursive calls
          0  db block gets
         84  consistent gets
          1  physical reads
          0  redo size
        413  bytes sent via SQL*Net to client
        385  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          1  rows processed

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24237320/viewspace-1813345/,如需转载,请注明出处,否则将追究法律责任。

下一篇: remap_tablespace
请登录后发表评论 登录
全部评论

注册时间:2010-07-13

  • 博文量
    406
  • 访问量
    1027885