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

Home -> Community -> Mailing Lists -> Oracle-L -> open cursors...

open cursors...

From: Suzy Vordos <lvordos_at_uswest.com>
Date: Wed, 31 May 2000 14:13:20 -0600
Message-Id: <10514.107356@fatcity.com> 





Is there a way to identify which users(s) have an open cursor?  We are
frequently seeing "max open cursors exceeded", open_cursors is set to
400.  Sure, we can increase open_cursors, but I think the source is bad
application code, just not sure which user is executing it.  The only
user_name I've found in v$open_cursor is SYS.



Thanks,


Suzy
Received on Wed May 31 2000 - 15:13:20 CDT












Original text of this message













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