Re: What would happen if..?

From: Ben <>
Date: Fri, 14 Mar 2008 09:49:38 -0700 (PDT)
Message-ID: <>

On Mar 14, 12:32 pm, hpuxrac <> wrote:
> On Mar 14, 12:23 pm, Ben <> wrote:
> > 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?

honestly there are a lot of settings in our system that I look back on and couldn't begin to explain accurately why they were set to what they are or what the previous dba was thinking when he did something. I do know what cursors are though, but why 500 was decided on the "correct" number, nope, no idea, I wasn't part of that decision making process. We had layoffs a few years back and our sole dba was one of them, so now I'm sole dba and the past dba didn't really keep notes.

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

didn't think so. I'm assuming 1200 was the default number set for the metric in oem. It doesn't hurt to ask for others input though.

> 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.- Hide quoted text -
> - Show quoted text -
Received on Fri Mar 14 2008 - 11:49:38 CDT

Original text of this message