Home » RDBMS Server » Server Administration » issue in my database while number of users increases
issue in my database while number of users increases [message #551185] Mon, 16 April 2012 02:54 Go to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
hello experts,
we have an application and oracle is used as backend.some days ago an issue is raised that is when users increases to login then database get hanged then we increased the number of processes and then it worked fine , but now this same problem raised again while increasing the number of users ,is there any permanent solution for it to get rid off from the problem .
should there any changes be done in sga or pga memory area?

please tell me how should i fix this problem?

thanx in advance.
Re: issue in my database while number of users increases [message #551188 is a reply to message #551185] Mon, 16 April 2012 03:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Set the number of processes for your target workload.

Regards
Michel
Re: issue in my database while number of users increases [message #551192 is a reply to message #551188] Mon, 16 April 2012 03:24 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanx for reply sir,
is there need to expand the memory area of sga or pga?
thanx again.
Re: issue in my database while number of users increases [message #551193 is a reply to message #551192] Mon, 16 April 2012 03:32 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No unless there is a problem with the current settings.
Use Statspack/AWR to know where are the performances problems.

Regards
Michel
Previous Topic: how to give full access to other schema
Next Topic: SQL Plus no access
Goto Forum:
  


Current Time: Thu Mar 28 19:00:53 CDT 2024