分享一下我老师大神的人工智能教程!零基础,通俗易懂!http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识,造福人民,实现我们中华民族伟大复兴!
9. Oracle深度学习笔记——性能调优汇总
欢迎转载,转载请标明出处:http://blog.csdn.net/notbaron/article/details/50621026
数据字典高速缓存命中率
数据字典高速缓存命中率如下:
select (sum(gets-getmisses-fixed))/sum(gets)"data dictionary hit ratio" from v$rowcache;
data dictionary hit ratio
-------------------------
.975728791
参考95~99%
1. 硬解析过程
alter session set sql_trace=true;
alter system flush shared_pool;
select table_name from user_tables whererownum<=5;
打开TRC文件如下:
PARSING IN CURSOR #140195096140104 len=50dep=0 uid=0 oct=3 lid=0 tim=700865302 hv=17921204 ad='97a9d708'sqlid='83dx9sc0j2x5n'
select table_name from user_tables whererownum<=5
END OF STMT
PARSE#140195096140104:c=106000,e=131031,p=2,cr=727,cu=0,mis=1,r=0,dep=0,og=1,plh=5472353,tim=700865301
….
再执行相同的命令如下,查看TRC文件如下:
*** 2016-01-30 17:55:48.379
CLOSE#140195096140104:c=0,e=100,dep=0,type=0,tim=1039278193
=====================
PARSING IN CURSOR #140195096140104 len=50dep=0 uid=0 oct=3 lid=0 tim=1039279623 hv=17921204 ad='97a9d708'sqlid='83dx9sc0j2x5n'
select table_name from user_tables whererownum<=5
END OF STMT
PARSE #140195096140104:c=1000,e=937,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=5472353,tim=1039279622
……
发现命中。
使用tkprof处理一下:
具体使用,可以直接输入tkprof
打开结果文件如下:
select table_name
from
user_tables where rownum<=5
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- -------------------- ----------
Parse 2 0.05 0.06 0 5 0 0