Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
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?
Thanks for your answers!
- Lasse
Sybrand Bakker wrote:
> 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 - 17:03:45 CDT
Original text of this message