I am frequently getting ORA-00060 deadlock detected.
When i check for blocking and waiting session one of the session is from a user who is trying performing some action from the application GUI and another one is application related process. how can i prevent this deadlock from occuring because i dont know when user is going to perform any activity from GUI.
Kindly share your valuable views here.
Thanks in advance.