| osman |
Posted: Jan 29, 2008 03:02:54 AM |
Total Post: 6
Joined: Nov, 2007
|
what are the scenarios when any one asks that my database is hanging now and then ?
|
|
|
 shantanu |
| Posted: Jan 29, 2008 03:10:07 AM |  |
|
Total Post: 42
Joined: May, 2007
|
Database may hang in following scenarios :
Maximum number of processes exceeding the limit.
Problem with archiving redo logs / Arch log file system is 100% full.
It may also hang due to deadlock or cyclic dependency of 2 or more processes.
|
|
|
|
|
| Mohammed Taj |
| Posted: Jan 29, 2008 10:54:43 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
First check ALERT<SID>LOG file.
|
|
|
|
|
| Vishal |
| Posted: Jan 29, 2008 05:43:31 PM | |
|
Total Post: 37
Joined: Mar, 2006
|
There could be two situations:
1. Database completely hung
2. Database slow down
Database hung could happen because of multiple reason for e.g. unresolvable deadlock,etc. You can run hanganalyze command on database that time to check if any blockers are there.
In second point the database slow down could be becuase of multiple reasons again. To start with ,
a. check CPU, Memory, swap usage on OS
b. check number of users connected to database.
c. Tune SGA parameters
d. see state of the indexes, or is it full table scan. Adjust optimizer parameters.
e. If any of the above doesnt resolve then tune the application/sql
Hope this helps.
Vishal
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
