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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Number of open cursors

RE: Number of open cursors

From: Anderson, Brian <andersob_at_mail.dartnet.peachnet.edu>
Date: Wed, 30 Aug 2000 14:08:50 -0400
Message-Id: <10604.115891@fatcity.com> 





Try this to see how many you have per session.



select SID, count(sid) from v$open_cursor group by sid;



We used to have cursor troubles, and we ended up with OPEN_CURSORS of 1024.
Received on Wed Aug 30 2000 - 13:08:50 CDT












Original text of this message













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