Re: What would happen if..?

On Mar 14, 12:23 pm, Ben <benal..._at_yahoo.com> wrote:
> 10.2.0.2 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....

Do you understand what an open cursor is and why it has been set to 500 for the instance you are ( apparently ) supporting?

Since there are no silver bullets there also are no magic numbers here.

Well except for if you have a session that needs more open cursors than your instance is configured to support well that can be something that needs looked at and adjusted. That's similar to the consideration for how many processes your instance needs to support. Received on Fri Mar 14 2008 - 11:32:56 CDT