Database Tuning (MOSC)

MOSC Banner

DEADLOCK DETECTED ( ORA-00060 )

edited Jul 31, 2014 5:00AM in Database Tuning (MOSC) 8 commentsAnswered


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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center