Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Determining the appropriate value for open_cursors

Determining the appropriate value for open_cursors

From: Schauss, Peter <peter.schauss_at_ngc.com>
Date: Mon, 29 Aug 2005 16:07:00 -0400
Message-ID: <6591F529444E9748A546718B3D1A6701019B8346@xcgv2605.northgrum.com>


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-l
Received on Mon Aug 29 2005 - 15:09:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US