Re: oracle cause "load" on OS level very high.

From: Joel Rees <jreesmf_at_mac.com>
Date: 6 Aug 2002 22:23:52 -0700
Message-ID: <f0d5086.0208062123.2601865f@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 - 00:23:52 CDT