Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Determining the appropriate value for open_cursors
Is there a way to see what the "high water mark" is for the number of
simultaneously open cursors? (Oracle 8.1.7.4, AIX 5.2) I know that I
can determine the current value with:
select count(*) from (select distinct address,hash_value from v$open_cursor);
I would like, however, to see the what the maximum was since the last time the database was restarted.
Thanks,
Peter Schauss
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 29 2005 - 15:09:40 CDT
![]() |
![]() |