How to understand pare(soft/hard) in AWR report
来源:互联网 发布:网速测试软件 编辑:程序博客网 时间:2024/06/13 12:45
我们经常关注AWR report中pase cpu to pase elapsd % 参数,它表示sql在解析过程中使用cpu的时间占用总时间的百分比,我们希望它接近100,这样sql在解析的过程中没有其它事件在等待。
当我们发现此参数值比较低时,就要考虑sql在解析过程中等待什么事件,由那些事件触发它在等待(libary cache, row tx contention eg)。这时我们要考虑是否对oracle cbo optimizer调优,包括软、硬解析,以及其它等待事件的调整。
0 0
- How to understand pare(soft/hard) in AWR report
- How to generate AWR report manually
- How to understand scope in JavaScript closure
- Man, hard to understand.
- How to Set isIgnorePagination in Jasper Report
- How to Understand Catalina
- how to understand fft
- How to reduce CPU soft lock up in KVM guest
- How to Generate an AWR Report and Create Baselines (文档 ID 748642.1)
- How to Interpret the OS stats section of an AWR report (文档 ID 762526.1)
- How To Sort Items in a CListCtrl in Report View
- Hard to understand what others' are saying ...
- hard link and soft link in Linux
- ABAP - REPORT - How to add user-pushbutton in selection screen
- How to schedule and get the report in SCOM2012
- In order to understand C++
- awr report
- How to Understand Your Users with Personas
- mysql-5.6.16-winx64.zip 安装
- Hibernate SQLQuery 原生SQL 查询及返回结果集处理-1
- 内存溢出与内存泄漏区别
- Search in Rotated Sorted Array
- gf_file_to_blob(string file1,blob blob1) pb 读取文件到大字段变量
- How to understand pare(soft/hard) in AWR report
- cocos2d-x图片变灰或者变亮
- Hibernate SQLQuery 原生SQL 查询及返回结果集处理-2
- 关于最短路径的探讨与证明
- The difference between the private and public clouds
- android 中Fragment的生命周期1
- ubuntu 搜狗安装搜狗输入法(fcitx)亲测有用
- Servlet 工作原理解析
- MSDN的使用及VC6.0的调试