Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Why MTS/Shared Server doesn't use round-robin?

Why MTS/Shared Server doesn't use round-robin?

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Thu, 24 Mar 2005 22:04:22 GMT
Message-ID: <424336b3.28510986@localhost>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US