Don't have a very scientific answer for you. The best I can tell you is
that it depends on how many processes you need. We have a data
warehouse and the processes is somewhere around 150. We have a web
application database with processes set around 600. In the case of the
web application, the application servers can create a maximum of 500
connections so I set the limit high enough to allow that plus some
extra.
The amount of memory needed will depend on how much memory each session
is given. You can set the pga_aggregate_target and then oracle can
advise you about how much better performance would be if you added
additional memory or reduced it. If you don't use pga_aggregate_target,
but instead set the individual parameters, usage will depend on how you
allocate memory for the pga.
-----Original Message-----
From: Jaspal
[mailto:oracledba-ezmlmshield-x84571024.[Email address protected]
Sent: Thursday, May 03, 2007 8:53 PM
To: LazyDBA Discussion
Subject: Number of oracle procceses
Hi
Can some please advise me on how what should be the determining factors
when sizing the proccesses parameter. How much memory does each process
use if any?
Regards,
j
------------------------------------------------------------------------
For important statutory and regulatory disclosures and more information
about Barclays Capital, please visit our web site at
http://www.barcap.com.
Internet communications are not secure and therefore the Barclays Group
does not accept legal responsibility for the contents of this message.
Although the Barclays Group operates anti-virus programmes, it does not
accept responsibility for any damage whatsoever that is caused by
viruses being passed. Any views or opinions presented are solely those
of the author and do not necessarily represent those of the Barclays
Group. Replies to this email may be monitored by the Barclays Group for
operational or business reasons.
Barclays Capital is the investment banking division of Barclays Bank
PLC, a company registered in England (number 1026167) with its
registered office at 1 Churchill Place, London, E14 5HP. This email may
relate to or be sent from other members of the Barclays Group.
------------------------------------------------------------------------
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This e-mail is confidential. If you are not the intended recipient, you must not disclose or use the information contained in it. If you have received this e-mail in error, please tell us immediately by return e-mail to Email.[Email address protected] and delete the document.
E-mails containing unprofessional, discourteous or offensive remarks violate Sentry policy. You may report employee violations by forwarding the message to Email.[Email address protected]
No recipient may use the information in this e-mail in violation of any civil or criminal statute. Sentry disclaims all liability for any unauthorized uses of this e-mail or its contents.
This e-mail constitutes neither an offer nor an acceptance of any offer. No contract may be entered into by a Sentry employee without express approval from an authorized Sentry manager.
Warning: Computer viruses can be transmitted via e-mail. Sentry accepts no liability or responsibility for any damage caused by any virus transmitted with this e-mail.
Oracle LazyDBA home page