| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> ResourceLeak with dynamic sql (7.3.3 Workgroupsserver) ?
Hi there,
did anyone know if there exists a resource problem/leak on using the
package DBMS_SQL
(We use Oracle 7.3.3 Workgroups-Server running under windows NT 4.0)
We execute a lot of great transactions with dynamic SQL, after a while
dynamic sql will not work any
longer in any session. If we terminate all sessions and try to
perform a dynamic sql call it will not work too.
Shut down of the instance (type immediate) makes after this some
problems too. Only shutdown (type abort) will work correct.
After startup of the instance dynamic sql will work properly again.
Any help out there? Thanks.
L&S Hochfrequenztechnik GmbH
Hermann Renfranz
Im Gewerbegebiet 31
D77839 LICHTENAU
Germany
Phone: +49 7227 9535-26
FAX: +49 7227 8982
mailto:hrenfranz_at_lsgermany.de
http://www.lsgermany.de
==================================================
Received on Thu Sep 02 1999 - 02:40:30 CDT
![]() |
![]() |