Re: Max open cursors

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Wed, 8 Mar 2000 13:40:09 GMT
Message-ID: <38C65839.B6EBAAC3@edcmail.cr.usgs.gov>

> I hope an expert can jump in this thread because I'm not. My
> understanding of OPEN_CURSORS is the maximum number of curosrs *a
> session* can have, while V$OPEN_CURSOR contains every sessions' curcors,
> so you can have a total of much more than what your OPEN_CURSORS is.

This is true. If OPEN_CURSORS is set to 500, then each session can have as many as 500 open cursors. It there are 10 sessions active, then you can have as many as 5000 open cursors.

HTH,
Brian

--

---

Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my company!

---

Received on Wed Mar 08 2000 - 07:40:09 CST