Re: cursors-related oracle parameters

From: Yong Huang <yong321_at_yahoo.com>
Date: 28 Aug 2003 12:16:26 -0700
Message-ID: <b3cb12d6.0308281116.59a77519@posting.google.com>

"Syltrem" <syltremzulu_at_videotron.com> wrote in message news:<JN63b.349$G1.1688_at_tor-nn1.netcom.ca>...
> I would like to find a way to best calculate a good value for
> session_cached_cursors. I thought setting it to a value that would be enough
> to serve most client sessions, should be fine (i.e. if most clients have
> less than 100 cursors open, set it to 100).

Hi, Syltrem,

The statistics "session cursor cache count" and "session cursor cache hits" in v$sesstat can be used to tune session_cached_cursors. Read the description in the Reference manual.

Yong Huang Received on Thu Aug 28 2003 - 14:16:26 CDT