数据库|mysql教程
Oracle教程,Oracle查看sql执行计划和统计信息,
数据库-mysql教程
android 蓝牙串口 源码,vscode输出结果,ubuntu字体是中文吗,tomcat9.0.17,sqlite设置排序ID,翻转时钟 插件,三大前端框架比较,爬虫抓取图片Python,php 第一天,百度调整seo,国外投资公司网站源码,会员后台网页模板,校园订餐系统模板,phpcms 设置404页面,单位人员档案管理系统源码,对用java开发的ftp客户端程序的评价lzw
–获取sql的执行计划以及统计信息,不显示查询信息 SQLgt; set autotrace traceonly;SQLgt; select * from test;执行计划—–
微信小程序商城系统源码,Ubuntu开机卡在动画,阿里服务器运行tomcat,python 学爬虫,php读取扫码枪,Seo141lzw
c 仿360安全桌面源码,vscode 初音跳舞,ubuntu的gho,上传目录至tomcat,爬虫 词库,php 相同的元素个数,驻马店seo外包价格,怎么搭建手机网站源码,帝国cms团购模板lzw
首页 → 数据库技术
背景:
阅读新闻
Oracle查看sql执行计划和统计信息
[日期:-08-31]
来源:Linux社区
作者:AnyJack
[字体:]
–获取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
————————————————————————————-
1t1
2t2
执行计划
———————————————————-
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
0
用SAS宏实现Oracle中的decode函数
Oracle RMAN 丢失归档日志:ORA-19625: error identifying file
相关资讯
Oracle教学
图片资讯
本文评论
查看全部评论 (0)
评论声明
最新资讯
本周热门