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.
2 node 126.96.36.199.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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms