Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Why MTS/Shared Server doesn't use round-robin?
Question in the subject line..
And what would the method used by Oracle be called? First non-busy? Last Recently Used/Non-Busy?
Reason I ask:
We have an in-house app-server, that takes requests from apache. There
is X such (app server) processes. Each has a one-to-one relationship
with a connection (each has a db connection).. Hence we do use
MTS/Shared Server.. The app server takes requests in round-robin.. I
figured that the app server would benefit from using similar algorithm
as Oracle. First (and I don't know much about OSes), the overhead on
the frontend (app server) should be lighter, since the OS would need
to put fewer processes on/off CPU (or page in/out, since i think
round-robin encourages paging).. and second I think there might be a
smaller overhead on the Oracle side since it has to manage fewer
'active' connections.
My thoughts are totally unsupported.. I tried googling for what other app servers or apache does; tried searching for algorithm advantages, however, as you can see I don't even know what's the 'something' going to be in round-robin vs "something". Looking for some pointers from fellow knowledgeable oracle professionals, don't have time to read up on how OS works (but would be happy to if someone narrows it down for me)
Thanks,
The App server runs on solaris 8
.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes
remove NSPAM to email
Received on Thu Mar 24 2005 - 16:04:22 CST