Question:
All the users are complaining that their application is hanging. How you will resolve this situation in OLTP
Answer:
If the user is complaining the hang problem ..then the experience of a dba reflects the work style that he is going to perform and basically as the rule suggest first try to connect to the database itself and fire some query to check whethere you are allowed to connect or not if you are connected then check for any locked_objects by checking v$locked_object and dba_waiters and dba_blockers.then you have to eliminate the things which are working properly and targetting yourself to the weaker place and then check at os level that which process is consuming the most of the time and then analyze the problem if the problem relates to a single user process then check what that user is doing by checking the sql statement he is firing.than so on Source: CoolInterview.com
If no one is able to connect with database except sys dba, then check for archive log destination, some time database hangs when archivelog destination got full. Source: CoolInterview.com
Answered by: kunal Mishra | Date: 7/9/2009
| Contact kunal Mishra
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|