Oracle查看sql执行计划和统计信息

--获取sql的执行计划以及统计信息，不显示查询信息
SQL> set autotrace traceonly;
SQL> select * from test;
执行计划
----------------------------------------------------------
Plan hash value: 1357081020
--------------------------------------------------------------------------
| Id | Operation         | Name | Rows | Bytes | Cost （%CPU）| Time     |
--------------------------------------------------------------------------
|   0 | SELECT STATEMENT |      |     2 |   130 |     3   （0）| 00:00:01 |
|   1 | TABLE ACCESS FULL| TEST |     2 |   130 |     3   （0）| 00:00:01 |
--------------------------------------------------------------------------
Note
-----
   - dynamic sampling used for this statement
统计信息
----------------------------------------------------------
          0 recursive calls
          0 db block gets
          8 consistent gets
          6 physical reads
          0 redo size
        523 bytes sent via SQL*Net to client
        416 bytes received via SQL*Net from client
          2 SQL*Net roundtrips to/from client
          0 sorts （memory）
          0 sorts （disk）
          2 rows processed
==============================================================
--只显示统计信息
SQL> set autot traceonly stat;
SQL> select * from test;
统计信息
----------------------------------------------------------
          0 recursive calls
          0 db block gets
          8 consistent gets
          0 physical reads
          0 redo size
        523 bytes sent via SQL*Net to client
        416 bytes received via SQL*Net from client
          2 SQL*Net roundtrips to/from client
          0 sorts （memory）
          0 sorts （disk）
          2 rows processed
==============================================================
--只显示执行计划
SQL> set autot traceonly exp;
SQL> select * from test;
执行计划
----------------------------------------------------------
Plan hash value: 1357081020
--------------------------------------------------------------------------
| Id | Operation         | Name | Rows | Bytes | Cost （%CPU）| Time     |
--------------------------------------------------------------------------
|   0 | SELECT STATEMENT |      |     2 |   130 |     3   （0）| 00:00:01 |
|   1 | TABLE ACCESS FULL| TEST |     2 |   130 |     3   （0）| 00:00:01 |
--------------------------------------------------------------------------
Note
-----
   - dynamic sampling used for this statement
==============================================================
--开启sql跟踪,显示查询结果和执行计划，以及统计信息
SQL> set autot on;
SQL> select * from test;
      T_ID   T_NAME
-------------------------------------------------------------------------------------
         1      t1
         2      t2
执行计划
----------------------------------------------------------
Plan hash value: 1357081020
--------------------------------------------------------------------------
| Id | Operation         | Name | Rows | Bytes | Cost （%CPU）| Time     |
--------------------------------------------------------------------------
|   0 | SELECT STATEMENT |      |     2 |   130 |     3   （0）| 00:00:01 |
|   1 | TABLE ACCESS FULL| TEST |     2 |   130 |     3   （0）| 00:00:01 |
--------------------------------------------------------------------------
Note
-----
   - dynamic sampling used for this statement
统计信息
----------------------------------------------------------
          0 recursive calls
          0 db block gets
          8 consistent gets
          0 physical reads
          0 redo size
        523 bytes sent via SQL*Net to client
        416 bytes received via SQL*Net from client
          2 SQL*Net roundtrips to/from client
          0 sorts （memory）
          0 sorts （disk）
          2 rows processed
==============================================================
--关闭sql跟踪,只显示查询结果
SQL> set autot off;
SQL> select * from test;
      T_ID    T_NAME
-------------------------------------------------------
         1        t1
         2        t2用SAS宏实现Oracle中的decode函数Oracle RMAN 丢失归档日志：ORA-19625: error identifying file相关资讯 Oracle教程

Oracle中纯数字的varchar2类型和（07/29/2015 07:20:43）
Oracle教程：Oracle中查看DBLink密（07/29/2015 07:16:55）
[Oracle] SQL*Loader 详细使用教程（08/11/2013 21:30:36）

Oracle教程：Oracle中kill死锁进程（07/29/2015 07:18:28）
Oracle教程：ORA-25153 临时表空间（07/29/2015 07:13:37）
Oracle教程之管理安全和资源（04/08/2013 11:39:32）

本文评论查看全部评论（0）