DEADLOCK DETECTED ( ORA-00060 )
Hi,
we are facing dead lock signal ORA-00060 also in the concerned trace files we are having holder / waiter session details along with sql's .But don't have complete sql's in last line some columns for where condition is missing.
FYI, above error is coming more than 45 to 50 time perday, perhaps within 3 to 4 mins blocking & waiting sessions are vanishing, which implies sql's are executed ????..
I want to capture the sql's and waited time for lock also need to discuss the same with Development team in order to pro-actively fix the peformance issue in our Database.
so I need to caputre the SID - blocking/wiating along with respective sql's automatically into any customized table using dbms_jobs, or if it is possible through AWR tables then