Re: What would happen if..?

On Mar 17, 8:15 am, Ben <benal..._at_yahoo.com> wrote:
> On Mar 14, 2:10 pm, vitalis..._at_gmail.com wrote:
>
>
>
>
>
> > On 14 mar, 17:23, 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....
>
> > Hi Ben,
>
> > Yes, 1200 is the default, you can lookup that up in the OEM guide.
> > Check whether there really are that many open cursors (~7828) when the
> > alert is raised. IIRC there used to be a bug regarding this instance-
> > wide statistic (I haven't kept the specifics though.)
>
> > Jerome- Hide quoted text -
>
> > - Show quoted text -
>
> Looking over my documentation library that was included on the disks,
> I don't see an OEM guide. Just a 2 day dba guide on oem. Link?- Hide quoted text -
>
> - Show quoted text -

nevermind found it. Received on Mon Mar 17 2008 - 07:51:58 CDT