just to be sure - you 'are' using MTS, right ?
"Dominica Leung" <dominica_l_at_yahoo.com> wrote in message
news:5f8af180.0208071234.77fa06b5_at_posting.google.com...
> Hi All,
>
> Thanks for everyone's help.
>
> I don't think I got attack.
>
> Forget about the cronjob now,
> this morning,
> this machine 's "load" went up to 200.
> It is VERY RIDICULOUS.
>
> I do "vmstat" and find out
> it is paging out a lot.
>
> I think this small E420R has 940 oracle processes is really
> maxing out the capacity of the machine.
>
> I do "talk" to a good friend, he know Oracle quite well
> on the phone when it happens.
> Both he and me draw to the conclusion of this machine
> just can't keep up with all the request.
>
> Actually, those SQL statement is very short select,
> and every 8 request ,1 is a delete .
>
>
>
> Dominica
Received on Wed Aug 07 2002 - 16:14:16 CDT
