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