Setver-side connection pooling
I've got a small Oracle-based application on my hands with about 2000 concurrent connections at any time doing mostly simple CRUD things. Should it in theory benefit from connection pooling? If so, does it suffice to turn server-side DRPC? Does it need a change in tnsnames.ora for clients to make use of it, or does setting dbms_connection_pool.start_pool() is enough? I am not sure how to persist this config...
Posted Sep 9, 2024, 5:51 AM UTC
11