OPEN_CURSORS

  • From: Bill Zakrzewski <bill@xxxxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 20 Dec 2011 16:46:27 -0500

All -

Oracle 10.2.0.5.0
RH Linux

Is the OPEN_CURSORS initialization parameter setting for a session or the 
entire database.  If OPEN_CURSORS is set to 500, can each session have 500 open 
cursors before exceeding the maximum?

Thanks,
Bill--
http://www.freelists.org/webpage/oracle-l


Other related posts: