oracle cause "load" on OS level very high.

From: Dominica Leung <dominica_l_at_yahoo.com>
Date: 6 Aug 2002 14:59:26 -0700
Message-ID: <5f8af180.0208061359.6cac32d6@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.

---

last pid:  8806;  load averages:  40.00,  8.57,  9.67                 
               14:50:39

928 processes: 923 sleeping, 2 running, 3 on cpu CPU states: 32.9% idle, 54.0% user, 13.0% kernel, 0.0% iowait, 0.0% swap
Memory: 4096M real, 133M free, 282M swap in use, 1254M swap free

---

It only spike up for 3 or 4 minutes.

When I do top, I only see the
PID is 25923, which is
the oracle 25923 1 0 Jun 29 ? 1031:47 ora_dbw0_USRDEV

My question is ?
1) is there anything I should look??
I have looked at V$lock, v$transaction at that time, there is NO PROCESS waiting for transaction, only 14 locks in the whole system.

Curious how to improve it, look like database writer is very busy.

I know people might told me "this machine is MAX out" in the capacity. But I hope there is something I could do about it.

Thanks,

Dominica Received on Tue Aug 06 2002 - 16:59:26 CDT