Rick,
Thanks for your help. They use ColdFusion MX JDBC.
From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx> Reply-To: oracle-l@xxxxxxxxxxxxx To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx> Subject: RE: Obsolete Initialization Parameters Date: Mon, 23 Feb 2004 14:20:44 -0600
Is this from Windohs ODBC connections? If so, check to see if checking "Enable closed cursors" on the offending clients will help. I believe it's a coding problem, but this was a viable workaround for a vendor app that bumped into 5000 open cursors between <10 connections.
BTW, we used this to track down our offending user on 8.1.7.4.0:
SELECT voc.sql_text, vs.username, vs.osuser, count(*) FROM v$open_cursor voc, v$session vs WHERE voc.address = vs.sql_address GROUP BY voc.sql_text, vs.username, vs.osuser ORDER BY 4 DESC;
HTH! GL! Rich
Rich Jesse System/Database Administrator rich.jesse@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA
-----Original Message----- > From: David Boyd [mailto:davidb158@xxxxxxxxxxx] > Sent: Monday, February 23, 2004 1:37 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: Obsolete Initialization Parameters > > > Hi List, > > We got ORA-1000 errors "Too many open cursors" and our > open_cursors is set > to 1000. I was wondering if it's better to increase > open_cursor or set > CLOSE_CACHED_OPEN_CURSORS = true to resolve the problem. I know > CLOSE_CACHED_OPEN_CURSORS is an obsolete initialization > parameter in Oracle > release 8.1. If I want to set CLOSE_CACHED_OPEN_CURSORS = > true, do I have > to set _close_cached_open_cursors=true? Or is it better to > ask developer > using SET_CLOSE_CACHED_OPEN_CURSORS Procedure in the application? ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------
---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------