RE: All the users are complaining that their applicati...
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
RE: All the users are complaining that their applicati...
1. Check whether the execution plan of various SQL statements have been changed which may happen due to Bulk inserts and updates. 2. Try to gather statistics on regular basis. 3. Check the server side resources using top vmstat iostat sar utilities. 4. Check the storage side 5. Check the network side
RE: All the users are complaining that their application is hanging. How you will resolve this situation in OLTP
If problem is pertaining to database & a user dont have acess to database level . One can check the process ( taking long time ) through the enterprise manager.