troubleshooting Question

Persistent connection explanation

Avatar of Pampa
Pampa asked on
Apache Web Server
2 Comments1 Solution229 ViewsLast Modified:
I'am trying to use persistent connections to connect to ORACLE.
My doubt is they are working fine?

So....

In Apache I have the following params:

KeepAlive Off
MaxKeepAliveRequests 100
MinSpareServers 5
MaxSpareServers 10
StartServers 5


So I monitoring the ORACLE conections:

I see that every user open a new connection to ORACLE for each child process so
Every user open (between 5 and 10) connections to ORACLE.

If another users connects uses the same child process to connect to ORACLE, but of course opeens a new connection.
Query of connectiosn :

osuser,machine,process,username
1)nobody DALILA 12324 LAMOR
2) nobody DALILA 12324 CBRUSSA
3) nobody DALILA 12324 FPADILLA
4) nobody DALILA 12325 FPADILLA


So my questions are:
1) Shouldn't be ONLY one connection per user?
2) A Persistent connection is open EVERY child process?
3) How can I do to open ONLY one connection per user and NO as many as child process?  

Thanks,
Fernando
ASKER CERTIFIED SOLUTION
BigRat

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros