Message-Id: <10640.118638@fatcity.com> From: "Veera Prasad" Date: Thu, 05 Oct 2000 14:35:32 -0400 Subject: Re: cursors and processes --------------7BD476BE6E00235A66511370 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit It depends on value been specified in initSID.ora initialization parameter file. To see the value type at sql prompt like SQL> show parameter open_cursors An you can see the view V$open_cursor to see the active cursors open. Jeff Wiegand wrote: > > > hi all. We are experiencing a bottleneck, using servlets and JDBC. I > understand what a cursor is and a process. But just how many processes > can we have? Is there a limit on the number of open cursors that > Oracle can efficiently handle? --------------7BD476BE6E00235A66511370 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit It depends on value been specified in initSID.ora  initialization parameter file.
To see the value type at sql prompt like SQL> show parameter open_cursors
An you can see the view  V$open_cursor to see the active cursors open.

Jeff Wiegand wrote:

 

hi all. We are experiencing a bottleneck, using servlets and JDBC. I understand what a cursor is and a process. But just how many processes can we have? Is there a limit on the number of open cursors that Oracle can efficiently handle?

--------------7BD476BE6E00235A66511370--