Wait event: enq: HW – contention | ANBOB
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进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论