Determining the appropriate value for open_cursors
- From: "Schauss, Peter" <peter.schauss@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 29 Aug 2005 16:07:00 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
