note 21473 deleted from oci8.installation by cmb
| From: | cmb@php.net | Date: | Sun, 20 Oct 2019 08:53:44 +0000 |
| Subject: | note 21473 deleted from oci8.installation by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-212705@lists.php.net to get a copy of this message | ||
Note Submitter: ddc at portalframework.com
----
Sometimes Oracle doesn't cleanup shadow processes when accessed from PHP. To avoid that, check
your
$ORACLE_HOME/network/admin/tnsnames.ora file in your Oracle Client directory and remove the
(SERVER=DEDICATED) token if is set.
To let Oracle delete shadow process on timeouts, add the following line in your
$ORACLE_HOME/network/admin/sqlnet.ora
found in your ORACLE Server directory:
SQLNET.EXPIRE_TIME=n
Where 'n' is the number of minutes to let connection idle befor shutting them out.