Connection exceeds limit error for external db - Root cause?

Hi All,

We are getting connection exceeds limit errors on external Oracle DB frequently. Max size has been set as 300 on DB side.

As an interim measure, we are increasing this limit but what could be the possible reasons from Appian side which could result in this issue?

1)How do the Appian to DB connections work in nutshell? Do the connections get close automatically when a query execution is complete via query rule, query entity or stored procedure?

2)Can multiple DB calls on an interface result in lot of new number of DB connections?

3)What could keep the connection open from Appian to external DB side? Any suggestions?

4)Can we check the number of active connections to DB on Appian side? If yes, which logs would help here?

5)Can an upgrade to higher Appian version which allows parallel DB calls be a reason for this kind of issue if there are more queries happening on the DB at same time?

Any pointers or suggestions welcomed:)

Thanks.

Hitesh