creating inactive session with oracle database, which is overloading the server

[mukhtar9]

Summary of problem or feature request

my database is on a different server from apache server with each request database, an active session is opened but this active session is not closed and remains as inactive session in DB server for example, my request count is 100 then an active session with the database is near to 100 and inactive sessions is 1000, and it grows with time span and overloads the database server

Code snippet of problem

System details

• Operating System Ubantu 18
• PHP Version 7.2
• Laravel Version 7
• Laravel-OCI8 Version oci8_12c instant client

[yajra]

Not sure but maybe persistent configuration might help?

'options'   => [
        PDO::ATTR_PERSISTENT => true,
],

[github-actions[bot]]

This issue is stale because it has been open for 30 days with no activity.

[github-actions[bot]]

This issue was closed because it has been inactive for 7 days since being marked as stale.