|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #41594 Statement cache is flushed too frequently
Submitted: 2007-06-05 00:50 UTC Modified: 2007-06-05 07:49 UTC
From: christopher dot jones at oracle dot com Assigned:
Status: Closed Package: OCI8 related
PHP Version: 5.2.3 OS: Linux x86
Private report: No CVE-ID: None
 [2007-06-05 00:50 UTC] christopher dot jones at oracle dot com
In oci_statement.c both calls to OCIStmtRelease() pass the OCI_STRLS_CACHE_DELETE flag. This means the statement cache (configure d with oci8.statement_cache_size) is flushed.  There should be no reason to flush the cache at these points.  

The fix is to change both OCI_STRLS_CACHE_DELETE flags to OCI_DEFAULT.

With this change even a simple script repeating one statement in a loop proves Oracle is able to use the cache, reducing the number of times the statement is parsed by the DB.

The change will also benefit users of persistent connections.


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2007-06-05 07:49 UTC]
This bug has been fixed in CVS.

Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
Thank you for the report, and for helping us make PHP better.

PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Tue May 21 07:01:31 2024 UTC