How does the oracle adapter maintains connections to the database? does it manages a pool of connections to the database or it makes just a single connection to the database?
I need to inform my DBA on the number of connections that my oracle adapter could potentially make. Is there anyway for me to size this? Thanks!
Your DBA should be able to monitor the number of connections under the user id and get the information.
Hi, thanks for your reply. Just curious, if the adapter maintains just a single connection to the DB, if there is a slow SQL being executed, wouldn’t it put all the other requests on hold? Does that mean that having multiple adapters would be better for performance?
Yes, it would put other sql on hold.