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

Home -> Community -> Usenet -> c.d.o.server -> Re: Why do i see so high "Curs/Sess" in statspack?

Re: Why do i see so high "Curs/Sess" in statspack?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 26 Jun 2006 23:07:25 +0200
Message-ID: <t2j0a25ttlhmlvemgrg6vu9v7vkn0mj83n@4ax.com> 





On Mon, 26 Jun 2006 19:00:11 GMT, Brian Peasland
<oracle_dba_at_nospam.peasland.net> wrote:



>

>OPEN_CURSORS defines your maximum number of *open* cursors at any one 

>time, across all sessions in your instance.





From the docs



(


http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96536/ch1132.htm#REFRN10137



)


OPEN_CURSORS specifies the maximum number of open cursors (handles to
private SQL areas) *a session* can have at once


--
Sybrand Bakker, Senior Oracle DBA


Received on Mon Jun 26 2006 - 16:07:25 CDT












Original text of this message













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