Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Determining the appropriate value for open_cursors
This may help:
http://www.ixora.com.au/scripts/sql/session_cursor_cache.sql
On 8/29/05, Schauss, Peter <peter.schauss_at_ngc.com> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 31 2005 - 13:35:34 CDT
![]() |
![]() |