SQL> set autotrace on;
SP2-0618: 无法找到会话标识符。启用检查 PLUSTRACE 角色
SP2-0611: 启用 STATISTICS 报告时出错

SQL>conn / as sysdba
已连接。
SQL> grant select any dictionary to user;
授权成功。
SQL> conn? user/password
已连接。
SQL> set autotrace? on;
SQL> select * from v$version;

BANNER
----------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE??? 10.2.0.4.0????? Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Productio
NLSRTL Version 10.2.0.4.0 - Production

执行计划
----------------------
Plan hash value: 2696698428

------------------------------------------
| Id? | Operation??????? | Name????? | Rows? | Bytes | Cost (%CPU)| Time???? |
------------------------------------------
|?? 0 | SELECT STATEMENT |?????????? |???? 1 |??? 47 |???? 0?? (0)| 00:00:01 |
|*? 1 |? FIXED TABLE FULL| X$VERSION |???? 1 |??? 47 |???? 0?? (0)| 00:00:01 |
------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

?? 1 - filter("INST_ID"=USERENV('INSTANCE'))

统计信息
----------------------
??????? 250? recursive calls
????????? 0? db block gets
???????? 56? consistent gets
????????? 0? physical reads
????????? 0? redo size
??????? 470? bytes sent via SQL*Net to client
??????? 243? bytes received via SQL*Net from client
????????? 2? SQL*Net roundtrips to/from client
????????? 9? sorts (memory)
????????? 0? sorts (disk)
????????? 5? rows processed

?