暂无图片
暂无图片
暂无图片
暂无图片
暂无图片
Wait event: enq: HW – contention | ANBOB
675
15页
1次
2020-08-27
5墨值下载
ANBOB™
提供专业的ORACLE, MySQL, PostgreSQL数据库产品安装升级、性能调优、故障诊断、远程⽀持等服
务, QQ:85304522 Tel:(+86)134-365-60330
Bing search
Google search
Submit
⾸页
About Me(DBA张维照)
站内地图
Exadata Machine
GoldenGate
MongoDB
MySQL
ORACLE
ORACLE [C]系列
PostgreSQL
Redis
SQL Server
开发语⾔
点滴岁⽉
系统相关
⽼哥杂谈
Rss Feed
Mail
Twitter
Weibo
资助站长
⾸页 » ORACLE » Wait event: enq: HW – contention
Wait event: enq: HW – contention
2020/06/06
ORACLE
67 views
Wait event: enq: HW – contention已关闭评论
这是⼀套11G数据库,⼀线DBA反应是数据库活动会话很⾼, 要来⼀份AWR,显⽰数据库top
event中较⾼的是enq: HW – contention和enq: TX – row lock contention,⽽另⼀节点是有较⾼的
direct path read.
DB Name DB Id Instance Inst num Startup Time Release RAC
ANBOB 3391174999 anbob1 1 03-May-20 18:05 11.2.0.4.0 YES
Host Name Platform CPUs Cores Sockets Memory (GB)
anbob.com1 Solaris[tm] OE (64-bit) 512 64 4 1023.00
Snap Id Snap Time Sessions Cursors/Session Instances
Begin Snap: 88631 03-Jun-20 20:00:17 549 .6 2
End Snap: 88633 03-Jun-20 21:00:36 2293 2.7 2
Elapsed: 60.30 (mins)
DB Time: 47,824.25 (mins)
Report Summary
Load Profile
Per Second Per Transaction Per Exec Per Call
DB Time(s): 793.1 11.6 0.48 0.21
DB CPU(s): 21.5 0.3 0.01 0.01
Redo size (bytes): 397,274.5 5,831.3
Logical read (blocks): 1,254,716.0 18,417.0
Block changes: 2,235.9 32.8
Physical read (blocks): 576.7 8.5
Physical write (blocks): 107.4 1.6
Read IO requests: 223.2 3.3
Write IO requests: 79.5 1.2
Read IO (MB): 4.5 0.1
Write IO (MB): 0.8 0.0
Global Cache blocks received: 290.0 4.3
Global Cache blocks served: 205.6 3.0
User calls: 3,830.6 56.2
Parses (SQL): 1,433.6 21.0
Hard parses (SQL): 4.1 0.1
SQL Work Area (MB): 11.2 0.2
Logons: 1.9 0.0
Executes (SQL): 1,651.4 24.2
of 15
5墨值下载
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论

关注
最新上传
暂无内容,敬请期待...
下载排行榜
Top250 周榜 月榜