Re: Ocifreestatement() and shared memory error?
| From: | Rouvas Stathis | Date: | Thu, 19 Jul 2001 17:56:18 +0000 |
| Subject: | Re: Ocifreestatement() and shared memory error? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-58761@lists.php.net to get a copy of this message | ||
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.
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