Connection Pool overload problems solved!

If you are using a connection pool, then you are probably using your database server in the best way. But how do you stop lots of applications having lots of connection pools, which leaves you back in the runaway session count quagmire you were trying to avoid?
Follow me!
blog: connor-mcdonal...
twitter: / connor_mc_d
The Podcast!
podcasts.apple...
open.spotify.c...
Subscribe for new tech videos every week
Other social media channels here: linktr.ee/connor
Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla
#oracle #connections #performance

[@virajmokadam4719]

Thank you. I have suggested the same to our customer just a few days ago. 🙂

[@Elfcheg]

So strange... How come I've never heard there are connection pool imbedded into RDBMS? I'll look into it, thank you Sir once again! :D

[@amitbajaj1995]

Do you recommend this for a host of weblogic servers, the situation is that within 5-10mins lots of users login at portal when it is opened for a booking, the session time needs to be slightly long as booking , transaction takes time and DB gets overloaded utilizing memory nearly 90% and slowly stablizing as time passes and rate drops.

[@DatabaseDude]

There's an old saying - always queue *outside* of the database, because if you don't, people will queue anyway but for the wrong reasons (their database is smashed). So set you an appropriate upper limit on the connection pool size.

[@ahmedinomazic7032]

Great stuff, can you use DRCP for Oracle Forms 12c ?

[@DatabaseDude]

Forms insists on dedicated connections because it is stateful

[@ChillPlayer]

Great video, I might look again at DRCP ;) Is session draining and TAC possible with DRCP in a RAC environment when the application is not using a connection pool (or will it be with the new enhanced version)?

[@DatabaseDude]

draining is available in the STOP_POOL call. I'm unsure on TAC/TAF etc.

[@ChillPlayer]

@@DatabaseDudeDraining would suffice for most our needs. So how would relocating a service to another RAC instance work or relocating a whole RAC Onenode instance to another node? First relocate the service/database and then STOP_POOL with draining timeout or will the cluster handle everything automatically with srvctl relocate database/service?

[@eminussleepus5790]

is it safe to say DRCP is the future for Connection Pool for Oracle? DRCP > UCP

[@DatabaseDude]

hard to say - I think DRCP is a no-brainer. They can also be used together docs.oracle.com/en/database/oracle/oracle-database/19/jjucp/ucp-drcp-integration.html#GUID-54A8CF56-1FBD-4F4B-BE7E-CB169E9435F1