Главная страница | назад





Article #21725: Closing and reopening a prepared query with Oracle 8 causes memory leak.

Question:
When I close and reopen a query with Oracle 8 I notice a memory leak. What causes this?
Answer:
Every open of a Prepared query with Oracle 8 causes the Heapsize as reported from DbiGetSysInfo to grow. When HeapSize equals MemSize an Out of Memory exception occurs. The only workaround at this time is UnPrepare the query after every execution of the Query.

This error is know to occur with BDE 5.0, 5.0.1, 5.1.0 and 5.1.1. with Oracle clients 8.0.4 and 8.1.5.

At this time, we believe this problem to be caused by a memory leak in the Oracle client. A future version of the Oracle client may resolve this error.

Last Modified: 12-APR-00