enq: SQ - contention
来源:互联网 发布:淘宝怎么发宝贝链接 编辑:程序博客网 时间:2024/05/08 21:04
--每分钟执行情况
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 在测试
- enq: SQ – contention
- enq: SQ - contention
- enq: SQ - contention
- Oracle Study之-- enq:SQ contention等待事件
- enq: SQ
- enq:SQ contention / row cache lock / DFS lock handle(SV) 等待事件 说明
- enq:SQ contention / row cache lock / DFS lock handle(SV) 等待事件 说明
- enq:SQ contention / row cache lock / DFS lock handle(SV) 等待事件 说明
- dictionary cache —— row cache lock/enq: SQ - contention/DFS lock handle
- enq:SQ contention / row cache lock / DFS lock handle(SV) 等待事件 说明
- High "enq: SQ
- 等待事件:enq: SQ
- enq: PS - contention
- enq: TX - index contention
- enq: FB - contention
- enq: TS – contention
- enq: TO - contention
- enq:HW-contention
- iOS开发 : UIButton
- 最长回文串总结
- Quartz表达式
- 类型转换的一些备忘
- 不能减肥规划地方归属地第四个是
- enq: SQ - contention
- 输入 输出
- poj 1273 Drainage Ditches
- zoj 1193 (拓扑排序)
- ALAsset和ALAssetRepresentation详解
- 新手入职之Git篇
- 记录HttpURLConnection使用getInputStream带给我的困扰
- SQL数据库 - 基本操作、语句大全
- Leetcode优化:Validate Binary Search Tree