Every DBA encountered a situation like this in his/her life.
Below are few steps you can follow in sequence to tackle this.
If the user is complaining the hang problem.
First try to connect to the database itself and fire some query to check whether you are allowed to connect or not.
Check for any locked_objects by checking v$locked_object and dba_waiters and dba_blockers.
Then check at os level that which process is consuming the most of the time.
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.
HTH:-)
1 comment:
zzzzz2018.8.31
nike chaussure
prada handbags
pandora
coach outlet online
polo ralph lauren
football soldes
canada goose jackets
true religion outlet store
canada goose outlet
nike requin pas cher
Post a Comment