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.
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.