• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 228
  • Last Modified:

Neded to disable shared servers

I have 2 dispatchers on for shared server and most of the time I have 25-35 active connections should I stop the shared server connections.
0
dba1234
Asked:
dba1234
  • 4
  • 3
4 Solutions
 
slightwv (䄆 Netminder) Commented:
>>should I stop the shared server connections.

Depends.
Do you think there will be a benefit of dedicated connections over shared connections?
Do you have the resources available on the server to handle the memory for 25-35 connections?

I assume it was created as shared process for a reason.
0
 
dba1234Author Commented:
I have 20GB memory and most of the time only 30-70% is used and I never seeb any paging on this server.
0
 
dba1234Author Commented:
The connections in the shared server  are main connections. In the shared server they could be slow.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
slightwv (䄆 Netminder) Commented:
>>and most of the time only 30-70% is used

Then you 'should' be able to handle dedicated connections but we cannot say for sure.  You undererstand your users and what they are doing.

Do you not have a test system to see the impact of shared processs versus dedicated with your application?
0
 
DavidSenior Oracle Database AdministratorCommented:
Somewhat tongue in cheek, but if it ain't broke, don't fix it.....  Congrats if this is the worst performance issue in your system.
0
 
dba1234Author Commented:
i have test system but there are usually 2-3 active sessions. Please suggest if there is any way to test it.
0
 
slightwv (䄆 Netminder) Commented:
>>Please suggest if there is any way to test it.

Same way you test any proposed change:  capture before metrics, make a change, capture after change metrics.  Compare results.



Create a bunch of sessions, do a bunch of things, check menory usage and pcoess times.

Disable shared processes.

Create a bunch of sessions, do a bunch of things, check menory usage and pcoess times.

Compare results.
0
 
slightwv (䄆 Netminder) Commented:
What part of your question was left unanswered?

You do realize that a 'B' is a penalty for the Experts.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now