set autotrace on [configure]

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24237320/viewspace-1813345/