Description:
Under periods of heavy load or heavily intensive querying, database servers can experience deadlocking. Tracking such errors is time consuming and require a number of log files.
Solution:
To track down deadlocks, you can locate the following. These files are also useful if you provide those to CA Tech Support if you decide to create a support case.
- Any recent .trc files from the oracle\udump directory.
- The app-niku and bg-niku logs (make sure to include the logs spanning the time in which the problem occurred.).
- The app-access logs can be useful, but only if the enhanced logging is enabled. Please refer to the knowledgebase article, titled, "Clarity: How do I activate enhanced logging for app-access logs using Apache Tomcat?" for more information.
Keywords: deadlock, Oracle, udump, trc.