What would happen if..?

From: Ben <benalvey_at_yahoo.com>
Date: Fri, 14 Mar 2008 09:23:18 -0700 (PDT)
Message-ID: <b0331bae-4b88-4d72-a64d-4aa369ccc8af@x30g2000hsd.googlegroups.com> EE, aix 5.2 64bit

I have seen the metric reported in Enterprise Manager several times for "Current Open Cursors Count" on one of our database's home page/ screen. It's reporting it at 7828. This particular system has about 1200 individual sessions logged on during peak hours and drops down to about 500 during off hours. OPEN_CURSORS is set to 500 in this database.

What I don't understand is exactly why this metric is being reported to me and if it is just a default value that it has decided once there are x number of open cursors the threshold has been crossed and I'm going to raise a warning.

I guess what I'm really asking is, is there some magic number of open cursors that I should be worried about, or is it just reporting this open cursor count because by default there is a threshold set at 1200 open cursors that it is at warning status.

Is there some maximum number of open cursors for the entire instance that if we reach that number it's going to blow up shoot sparks out of the back of the server.... Received on Fri Mar 14 2008 - 11:23:18 CDT

Original text of this message