During Heavy Batch Jobs sun cluster diskgroup monitoring causing hang with enq: DD - contention (Doc ID 1537179.1)

Last updated on MARCH 13, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.

Symptoms

2 node 11.2.0.2.0 RAC Cluster (Oracle Cluster built on top of a Sun Cluster) in Production M9000 Machine.
Whenever batch jobs run with multiple threads (which also does a lot of i/o), then there is a build up of "enq: DD - contention Waits" processess in the ASM Instance
and these processess never die and they keep on building up.
When these "enq: DD - contention Waits" processess exceeds the processess value, then it is hitting ORA-00020 Error
and the database goes to hang state, as it does not allow any other new processess.

Once the application batch jobs finish, then these "enq: DD - contention Waits" processess will die away on their own and the system returns to normalency.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms