Re: OciLogoff, oracle sessions & OCIInternalDebug

On Thu, Jul 27, 2000 at 12:38:10PM -0700, Paul Fernandez wrote: > Hello there, > > If I have a page that starts with OCILogon , and ends with OCILogoff > command, does Oracle still keep a session open? the oracle-server connection will be closed when the request-end handlers are called. > > Would using persistent connections reduce the number of sessions used? no > > I have encountered the infamous Ora-00018 error. I get false errors, > such as "invalid column name" (because the query works just > fine)...Then, if you wait a few minutes, the error goes away and the > page performs as designed. oerr ora 00018 00018, 00000, "maximum number of sessions exceeded" // *Cause: All session state objects are in use. // *Action: Increase the value of the SESSIONS initialization // parameter. why no increase the sessins in init.ora? > > I am able to hit the session limit after running through my pages > roughly 60 times (the default Oracle sessions value, I've learned). > > Am I mistaken to assume that OCILogoff() frees up these sessions? if you use ocilogon the the connections will be cleared at request end! > > It all happens relatively fast: > > 1. OCIlogon > 2. run query > 3. display query data in HTML > 4. OCILogoff > > Also, since I have OciInternalDebug(1), I can see these messages on each > screen: > > OCIDebug: START php_rshutdown_oci > OCIDebug: END php_rshutdown_oci that's debug stuff! tc > > Any feedback is appreciated. > > -- > Paul Fernandez > Webmaster > Structural GenomiX, Inc. > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany