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.
dba1234Asked:
Who is Participating?
 
DavidConnect With a Mentor Senior 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
 
slightwv (䄆 Netminder)Connect With a Mentor 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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
dba1234Author Commented:
The connections in the shared server  are main connections. In the shared server they could be slow.
0
 
slightwv (䄆 Netminder)Connect With a Mentor 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
 
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)Connect With a Mentor 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
All Courses

From novice to tech pro — start learning today.