Is the load only occuring when these cronjobs run, if so, look at what tyey
are doing. There maybe something horrendously inefficient going on in there
HTH
Neil
"Joel Rees" <jreesmf_at_mac.com> wrote in message
news:f0d5086.0208062123.2601865f_at_posting.google.com...
> dominica_l_at_yahoo.com (Dominica Leung) wrote in message
news:<5f8af180.0208061359.6cac32d6_at_posting.google.com>...
> > Hi All,
> >
> >
> > I am wondering whether anyone seen this kind of situation
> > before in Performance tuning aspect.
> >
> > I am (this company AA) is running oracle 8.0.6.2
> > 32 bits on
> > solaris 2.6 OS.
> >
> > There is very strange thing happen.
> > When I do a "top",
> > everyday at 2:30 pm and 2:45PM
> > (there are some cronjob from Engr dept doing select and
> > update)
> > the "load" from the "top" command, will be 40.00.
> > This is very high, normal machine is 4 or 5.
>
> Aside from the normal questions about the cronjob, have you checked
> your security?
>
> We hava a server (on MSW2k) out at a customer's, which every now and
> then hits max processes, but doesn't come back down, so the customer
> re-boots. We've been looking at tuning, and looking for possible bugs
> in our app, but now we are also looking at the possibility of DOS
> attacks:
>
> http://otn.oracle.com/deploy/security/alerts.htm
>
> The one I'm most concerned with right now is this one:
>
> http://technet.oracle.com/deploy/security/pdf/net8_dos_alert.pdf
>
> Joel Rees
Received on Wed Aug 07 2002 - 06:45:12 CDT
