hi dbas:
how do i detect dead locks and how do i resolve it..
what are the types of locks that are important and need immediate action..
thanks