Re: OPEN_CURSORS
From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Wed, 21 Dec 2011 08:46:15 +0800
Message-ID: <CAM_ddu_d3XQX-d7ML0x=S4feAC7hCGvJobBoMruUBPh+S_HfMg_at_mail.gmail.com>
see the doc
http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams138.htm#REFRN10137 OPEN_CURSORS specifies the maximum number of open cursors (handles to private SQL areas) a session can have at once. You can use this parameter to prevent a session from opening an excessive number of cursors.
Date: Wed, 21 Dec 2011 08:46:15 +0800
Message-ID: <CAM_ddu_d3XQX-d7ML0x=S4feAC7hCGvJobBoMruUBPh+S_HfMg_at_mail.gmail.com>
see the doc
http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams138.htm#REFRN10137 OPEN_CURSORS specifies the maximum number of open cursors (handles to private SQL areas) a session can have at once. You can use this parameter to prevent a session from opening an excessive number of cursors.
--
Regards
Sidney Chen
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 20 2011 - 18:46:15 CST