Re: Ocifreestatement() and shared memory error?
| From: | Thies C. Arntzen | Date: | Fri, 20 Jul 2001 09:16:33 +0000 |
| Subject: | Re: Ocifreestatement() and shared memory error? | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-58865@lists.php.net to get a copy of this message | ||
On Thu, Jul 19, 2001 at 08:56:18PM +0300, Rouvas Stathis wrote:
> Michael Champagne wrote:
> >
> > We recently ran into Oracle error ORA-04031 which has something to do with
> > your shared memory being filled up or thrashed (I'm not a DBA so I'm vague on
> > this.) I noticed that a lot of the PHP code on the site is not using
> > ocifreestatement() or ocilogoff() after executing. Could this have caused
> > this problem? We restarted the database and now everything seems to work ok.
the php-oci driver does all that for you! there is no known
resource leakage in this driver. so this is no the cause of
your problem.
tc
>
> Always close Ora connections or else ...
>
> -Stathis.
>
> > We ran into the error inserting some records into a table with some triggers
> > on it.
> >
> > Thanks in advance,
> > Mike
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>