Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connection Pooling is Different from Shared Server Technology (MTS)??

567614Mar 18 2007 — edited Mar 28 2007
Greetings!

Do you agree that the Oracle "Shared Server" technology (MTS) is a totally separate concept from connection pooling?

The following is an excerpt from the below listed web page.

"For even better resource management, shared server can be configured for connection pooling. Connection pooling lets a dispatcher support more users by enabling the database server to time-out protocol connections and to use those connections to service an active session."

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14231/manproc.htm#i1010000

Does that excerpt refer to how Shared Server can be configured to work in conjunction with connection pooling, not to deliver connection pooling?

My understanding is that the SHARED_SERVERS capability in Oracle can help a database server that is at risk of becoming overloaded with processes. And, that is very seperate from connection pooling, which can result in potentially fewer connection objects consuming memory depending on how many users there are and how much idle time those users have. But, mainly, since connections in the pool remain open for quite some time waiting around for a user to make use of them, the processing-time expense of opening a brand new database connection every time a web page is requested is saved with connection pooling in place.

What are your thoughts? Did I misinterpret the excerpt I pasted from the above Oracle URL?

Thanks for your help!

Rachel
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2007
Added on Mar 18 2007
1 comment
3,173 views