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

Home -> Community -> Usenet -> c.d.o.misc -> Oracle Cursors

Oracle Cursors

From: MJ <martyn.jones.uk_at_ntlworld.com>
Date: Mon, 24 Feb 2003 13:19:37 -0000
Message-ID: <KZo6a.2895$J77.1254884@newsfep2-win.server.ntli.net> 





Hi



Does anyone know how to track what cursors are open by process.  I have a
problem where by an Oracle Database 8i (8.1.7) keeps generating ORA-01000
Maximum Cursors Exceeded.



I know I can keep increasing the MAX_CURSORS setting in init.ora but this is
not resolving the problem, only delaying it.



Regards



Martyn Jones
Received on Mon Feb 24 2003 - 07:19:37 CST












Original text of this message













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