My guess is that they are not using bind variables and it is causing the
high cpu usage due to all the hard parses. Have them fix it.
Jim
"Dominica Leung" <dominica_l_at_yahoo.com> 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.
>
> =========================================
>
> 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 - 19:14:04 CDT
