oracle查看sql执行计划和统计信息
来源:互联网 发布:云计算市场 gartner 编辑:程序博客网 时间:2024/05/22 07:58
oracle查看sql执行计划和统计信息
分类: oracle2011-08-30 11:16960人阅读评论(0)收藏举报
sqloracleaccesstabledisk
--获取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
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
from:http://blog.csdn.net/jlds123/article/details/6731851
- oracle查看sql执行计划和统计信息
- oracle查看sql执行计划和统计信息
- 在Oracle的SQL*PLUS中启用AutoTrace查看SQL执行计划和统计信息
- 如何在sqlplus中查看oracle数据库sql语句执行计划,执行时间和统计信息
- sqlplus中显示sql执行计划和统计信息
- 查看oracle sql 执行计划
- ORACLE 查看SQL执行计划
- ORACLE 执行计划 统计信息介绍
- 修改统计信息改变执行计划(ORACLE)
- oracle -执行计划的统计信息
- 如何查看oracle sql执行计划
- 【转】如何查看oracle sql执行计划
- 如何查看oracle sql执行计划
- 如何查看oracle sql执行计划
- 如何查看oracle sql执行计划 .
- Oracle 查看sql语句执行计划方法
- 多种方法查看Oracle SQL执行计划
- Oracle查看SQL语句的执行计划
- 第五周 项目一:三角形类(参数初始化表)
- opencv-形态学组合运算
- 对这几天服务器崩溃的小结
- 题目1066:字符串排序
- JMockit学习笔记(一,简介)
- oracle查看sql执行计划和统计信息
- Eclipse优化配置
- 第五周 项目一:三角形类(有默认参数的构造函数)
- 【腾讯马拉松3月23日】HDU 4525_威威猫系列故事——吃鸡腿
- 安防集成的未来,行业细分与中心平台双管齐下
- HDU 2079 选课时间 母函数
- 第五周 项目二:分数类
- python运行时修改代码的方法——monkey patch
- 如何直接修改exe文件