Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PROBLEM: Open Cursors

Re: PROBLEM: Open Cursors

From: Grinalds <g.geks_at_konts.NOSPAM.lv>
Date: Tue, 26 May 1998 10:19:41 +0300
Message-ID: <356A6D0C.F0FB3149@konts.NOSPAM.lv> 





See http:\\www.revealnet.com site. There was workaround on this problem,
that after using 3rd part tools remain opened cursors, when in select
statement use values, istead of bind variables. They wrote stored procedure
that each hour release memory.



Jorge Pereira wrote:



> The problem is that after some time of runing the applications, some


> cursors (sometimes 30..70) stay opened on the server after i close ALL


> the clients.



Received on Tue May 26 1998 - 02:19:41 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US