Bug #17043 Updated: Sessions and OCIPLogon

ID: 17043 Updated by: chansen@stromix.com Reported By: cunha@gabcmt.eb.mil.br Status: Closed Bug Type: OCI8 related Operating System: Linux 2.4.18 PHP Version: 4.2.0 New Comment: When I make an OCIPLogon, it one PHP page, all other users, even those not executing that page get affected. The outcome is a buildup of Inactive users on the Oracle server. I did read the manual, which is not very informative, as witnessed by the multiple threads on this very issue. My advice is don't use OCIPlogon, because it wastes resources, and each time you call it, a new persitent session will be created, which you cannot apparently kill, with out restarting Apache. Previous Comments: ------------------------------------------------------------------------ [2002-05-07 08:21:30] cunha@gabcmt.eb.mil.br thanx. ------------------------------------------------------------------------ [2002-05-07 07:47:11] thies@php.net This is not a bug. Please double-check the documentation available at http://www.php.net/manual/ and the instructions on how to report a bug at http://bugs.php.net/how-to-report.php as apache is multi-process you will have as many sessions as you have apache-processes. that's the way it is. we cannot share connections between different apache-processes. ------------------------------------------------------------------------ [2002-05-06 10:09:59] cunha@gabcmt.eb.mil.br When using OCIPLogon connecting to Oracle8i, it creates many sessions at the server. I want to know if this behavior is by design because it isn't correct. A persistent connection "must" be shared between any number of children(threads and/or process). Why so many sessions? ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=17043&edit=1