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

Home -> Community -> Mailing Lists -> Oracle-L -> SQLException: java.sql.SQLException: ORA-01000: maximum open cursors

SQLException: java.sql.SQLException: ORA-01000: maximum open cursors

From: Glenn Travis <Glenn.Travis_at_wcom.com>
Date: Mon, 06 Nov 2000 10:56:23 -0500
Message-Id: <10672.121217@fatcity.com>


We are receiving this error from our app (which is using JSP);  SQLException: java.sql.SQLException: ORA-01000: maximum open cursors exceeded

Database is 8.1.6.

open_cursors is set to 500 in the init.ora param file (we upped this from 100 last week).

When I check the open_cursors from the v$open_cursor view, I never see the values anywhere near 500!

Output of query;
 select saddr,sid,user_name,count(*) countcur from v$open_cursor group by saddr,sid,user_name
  order by 4,3

SADDR           SID USER_NAME                        COUNTCUR
-------- ---------- ------------------------------ ----------
8C0EF908         69 SYS                                     1
8C0E1A48         42 ESPADMIN                                3
8C0D4C08         17 CND                                     4
8C0D9E88         27 CNDI                                    4
8C0F2248         74 ESPADMIN                                4
8C0E6488         51 ESPADMIN                                5
8C0E2AC8         44 CND                                     6
                                                   ----------
sum                                                        27

Isn't the open_cursor param setting the open cursors per SESSION? If my value is 500, why do I keep getting the ORA-01000 error??? What is going on here? Am I seeing another param limit being reached and the ORA-01000 error getting thrown? Any help per advice is greatly appreciated.

PS. I am aware (from previous posts) that the v$open_cursor table actually shows ALL cursors (open,closed,cached), not just open cursors. I issue 'alter system flush shared_pool' and the output from this table goes down to 1 or 2. Then it starts to climb back up again. BUT it never reaches 500! Received on Mon Nov 06 2000 - 09:56:23 CST

Original text of this message

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