Re: Determining the appropriate value for open_cursors

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: peter.schauss@xxxxxxx
  • Date: Wed, 31 Aug 2005 19:33:35 +0100

This may help:
http://www.ixora.com.au/scripts/sql/session_cursor_cache.sql


On 8/29/05, Schauss, Peter <peter.schauss@xxxxxxx> wrote:
> 
> Is there a way to see what the "high water mark" is for the number of
> simultaneously open cursors? (Oracle 8.1.7.4 <http://8.1.7.4>, AIX 5.2) I 
> know that I
> can determine the current value with:
> 
> -- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: