RE: ORA-1000 and pl/sql cursor cache

Subject: RE: ORA-1000 and pl/sql cursor cache Try playing with alternately setting session_cached_cursors to 0 and some non-zero value and run the following script. Try setting _close_cached_open_cursors to both true and false, changing which 'commit' is used, and omitting the 'commit

RE: ORA-1000 and pl/sql cursor cache

To: Multiple recipients of list ORACLE-L Subject: Re: ORA-1000 and pl/sql cursor cache David: I don't really know if this will help you, but it might be worth a try. You could try setting session_cached_cursors. Bjørn Engsig's white paper Efficient use of bind variables

RE: ORA-1000 and pl/sql cursor cache

. -- David Lord -Original Message- From: Barbara Baker [mailto:[EMAIL PROTECTED] Sent: 26 November 2003 16:49 To: Multiple recipients of list ORACLE-L Subject: Re: ORA-1000 and pl/sql cursor cache David: I don't really know if this will help you, but it might be worth a try

ORA-1000 and pl/sql cursor cache

Hi Does anyone know whether its possible to control the size of the pl/sql static cursor cache. I'm running into ORA-01000: maximum number of open cursors exceeded errors and part of the problem (apart from the usual developers not closing explicit cursors) is that _all_ static sql statements in

Re: ORA-1000 and pl/sql cursor cache

David: I don't really know if this will help you, but it might be worth a try. You could try setting session_cached_cursors. Bjørn Engsig's white paper Efficient use of bind variables, cursor_sharing and related cursor parameters describes this parameter a bit. It can be found at

Re: ORA-1000 and pl/sql cursor cache

To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ORA-1000 and pl/sql cursor cache Hi Does anyone know whether its possible to control the size of the pl/sql static cursor cache. I'm running into ORA-01000: maximum number of open cursors exceeded errors and part