| Application is Hanging. [message #64955] |
Wed, 17 March 2004 20:28  |
Sheshadri
Messages: 12
Registered: June 2002
|
Junior Member |
|
|
Hi,
My database is of around 2 GB and It is a development database.
Almost every day developers compain that their application is hanging. when it is hanging, status of session shows inactive for 20 to 30 sessions.
My database version is 9.2.0.1.0, OS platform is Windows 2000 and DB is running in NOARCHIVELOG mode.
Can you please tell me which parameters or other settings that I have to look into for solving this problem?
Thanks
Sheshadri
|
|
|
|
| Re: Application is Hanging. [message #64963 is a reply to message #64955] |
Thu, 18 March 2004 04:29  |
Frank Naude
Messages: 4581
Registered: April 1998
|
Senior Member |
|
|
Hi,
You can also check the following:
1. Database locks
2. Messages in the database's alert log
3. OS activity - memory, disk, CPU and network usage
4. Messages in the System's event viewer
Etc.
Best regards.
Frank
|
|
|
|
| Re: Application is Hanging. [message #65001 is a reply to message #64955] |
Fri, 26 March 2004 09:06 |
Thomas G
Messages: 58
Registered: April 2003
|
Member |
|
|
How do you restart it ?
Can it still be shut down with "shutdown immediate" ?
I had a problem once where even that wasn't possible anymore, only "shutdown abort"
The problem was the standard DML_LOCKS parameter was to small. The problem was solved after doubling it. (to 4416 in my case, but I have about 200 - 250 user on the DB.)
You could also look into TRANSACTIONS_PER_ROLLBACK_SEGMENT
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
