Home » RDBMS Server » Performance Tuning » Application is Hanging.
Application is Hanging. [message #64955] Wed, 17 March 2004 20:28 Go to next message
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 Go to previous messageGo to next message
Frank Naude
Messages: 4565
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 Go to previous message
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
Previous Topic: Different way of execute
Next Topic: Shared Pool.
Goto Forum:
  


Current Time: Sat Sep 19 02:00:23 CDT 2020