Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

enq: HW - contention on RAC

User13512691-OracleNov 15 2011 — edited Nov 16 2011

Hi,

Using multiple insert sessions on same table we are having Wait event "enq: HW - contention". Tablespaces is local and assm is used.
version 10.2.0.4.0
Two node RAC.

Any suggestion to reduce? Thinking to allocate more freelists and freelistgroups manually to segment.
Segment is a partition in this case.

Regards

Edited by: user13512691 on Nov 14, 2011 10:25 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 14 2011

Added on Nov 15 2011

#performance-availability, #real-application-clusters

9 comments

2,321 views