enq: SQ - contention
--每分钟操作
SQL> select sql_id, mi, count(mi)
2 from (select event, sql_id, to_char(sample_time, 'yyyymmdd hh24mi') mi --,
3 --session_id
4 from dba_hist_active_sess_history
5 where sql_id = '7wxfw53bsmgpq'
6 and sample_time > to_date('20140717 0940', 'yyyymmdd hh24mi')
7 and sample_time < to_date('20140717 0950', 'yyyymmdd hh24mi'))
8 group by sql_id, mi
9 order by mi ;
SQL_ID MI COUNT(MI)
------------- ------------- ----------
7wxfw53bsmgpq 20140717 0942 1
7wxfw53bsmgpq 20140717 0943 23
7wxfw53bsmgpq 20140717 0944 125
7wxfw53bsmgpq 20140717 0946 96
7wxfw53bsmgpq 20140717 0947 114
7wxfw53bsmgpq 20140717 0949 44
通过图片,发现对 第一条获取序列的语句比較暂用性能
--等待事件以及语句情况
SQL> select event,sql_id, mi, count(mi)
2 from (select substrb(event,1.30) event, sql_id, to_char(sample_time, 'yyyymmdd hh24mi') mi --,
3 --session_id
4 from dba_hist_active_sess_history
5 where sql_id = '7wxfw53bsmgpq'
6 and sample_time > to_date('20140717 0940', 'yyyymmdd hh24mi')
7 and sample_time < to_date('20140717 0950', 'yyyymmdd hh24mi'))
8 group by event,sql_id, mi
9 order by mi ;
EVENT SQL_ID MI COUNT(MI)
---------------------------------------------------------------- ------------- ------------- ----------
7wxfw53bsmgpq 20140717 0942 1
buffer busy waits 7wxfw53bsmgpq 20140717 0943 1
enq: SQ - contention 7wxfw53bsmgpq 20140717 0943 22
buffer busy waits 7wxfw53bsmgpq 20140717 0944 3
enq: SQ - contention 7wxfw53bsmgpq 20140717 0944 122
buffer busy waits 7wxfw53bsmgpq 20140717 0946 2
enq: SQ - contention 7wxfw53bsmgpq 20140717 0946 94
buffer busy waits 7wxfw53bsmgpq 20140717 0947 2
enq: SQ - contention 7wxfw53bsmgpq 20140717 0947 112
buffer busy waits 7wxfw53bsmgpq 20140717 0949 1
enq: SQ - contention 7wxfw53bsmgpq 20140717 0949 43
--大小获取查询
SQL> select sequence_name,cache_size from dba_sequences where sequence_name like upper('%qreque%');
SEQUENCE_NAME CACHE_SIZE
------------------------------ ----------
QREQUESTNO 20 改成100 在測试
SQL>
--大小获取查询
SQL> select sequence_name,cache_size from dba_sequences where sequence_name like upper('%qreque%');
SEQUENCE_NAME CACHE_SIZE
------------------------------ ----------
QREQUESTNO 20 变100 在测试
版权声明:本文博客原创文章。博客,未经同意,不得转载。
最新文章
- JQuery教程
- Redis主从同步介绍
- mssql的delete用用到被delete的表的别名
- 定时显示div
- Column store index 列数据如何匹配成行数据?
- Android Material Design带UI变化
- JavaEE中的MVC(三)定制Struts——命令模式
- Mybatis+Oracle批处理
- JSP中的编译指令和动作指令的区别
- JAVA SPI(Service Provider Interface)原理、设计及源码解析(其一)
- PHPMYWIND4.6.6前台Refer头注入+后台另类getshell分析
- 启动tomcat出现内存溢出错误 java.lang.OutOfMemoryError: PermGen space
- 利用django-crontab设定定时任务
- 仿迅雷播放器教程 -- 基于VLC的MFC播放器 (6)
- ocacle sql: 两张表左连接 ,1对多,取一条数据,取按时间最新的
- ios导航栏和tabbar的坑
- Hadoop 客户端问题
- Spring的单例模式底层实现学习笔记
- latex编写论文
- AE中IHookHelper的用法 来自http://blog.sina.com.cn/s/blog_6faf711d0100xs1x.html