ORA-01000: maximum open cursors exceeded - Allround Automations forums

Register Log In

Forums Products Direct Oracle Access ORA-01000: maximum open cursors exceeded

Print Thread

ORA-01000: maximum open cursors exceeded #2246 07/17/01 08:07 PM
Joined: Jul 2001 Posts: 5 J jhui OP Member
OP jhui Member J Joined: Jul 2001 Posts: 5	Does anyone know anything about this error ? I have heard that Oracle v 8.0.6 has a cursor 'leak' when using LOBs. Can anyone confirm this ? If so, does anyone have a fix, or a link to some Oracle article or patch ? TIA Jan Huizinga Frontix BV

Re: ORA-01000: maximum open cursors exceeded #2247 07/18/01 03:51 PM
Joined: Aug 1999 Posts: 22,216 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,216	I'm not aware of such a bug, and I can't find it on Oracle MetaLink either. This does not mean that the bug does not exist of course [Linked Image]. ------------------ Marco Kalter Allround Automations Marco Kalter Allround Automations

Re: ORA-01000: maximum open cursors exceeded #2248 07/18/01 06:32 PM
Joined: Oct 2000 Posts: 8 Kristiansand, Norway O Ole Petter Member
Ole Petter Member O Joined: Oct 2000 Posts: 8 Kristiansand, Norway	Are you sure you have set value of the "open_cursors" value in the init.ora of the db-server properly high? I had the same problem, but it disappeared after I increased this parameter value. Ole Petter

Moderated by support

Link Copied to Clipboard

Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.029s Queries: 13 (0.010s) Memory: 2.5037 MB (Peak: 3.0420 MB) Data Comp: Off Server Time: 2024-05-13 01:23:55 UTC
Valid HTML 5 and Valid CSS