Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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