Oracle Database Discussions

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: HV - Contention

LauryFeb 12 2015 — edited Feb 16 2015

Hi,

I have an Oracle 11gR2 database running on Exadata.

For a long running batch/job, one of the Top wait event that i have is "enq:HV - contention".

I have found that adding the hint HWM_BROKERED in the relatded SQL-statement (this is an insert), can be a possible solution.

See Metalink Note: 452719.1

Does someone has experience with this hint? It disables some _* parameters. Why can this be a work-around?

Doing so, will not ensure that the HWM is protected.

Thanks and Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 16 2015

Added on Feb 12 2015

#general-database-discussions

4 comments

4,886 views