Threads hung while getting the connection intermittently

Hi Team,

Oracle Version: 12.2.0.1.0

ojdbc8.jar

Linux: 7.5

Refer to the below stack trace from the thread dump taken during the incident. We have a situation where Finastra Essence application is requesting for a new database connection (through WebSphere Application Server DataSource) and causing a hung thread.

• Essence application uses Hibernate as ORM for persistence.
• It relies on DataSource created in WebSphere Application Server.
• Hibernate is configured to use the this DataSource to get connections whenever needed.

There have been three Production incidents in last one week at Yoma Bank, where the below call is getting hung for longer than an hour (for the application to get a database connection).