Re: Help!!!!Peformance Tuning

"ORACLE APPRENTICE" <solarisch_at_gmail.com> wrote:
> I have problems about CPU loading and Oracle performance.
> The loading average is always higher than 1(which is abnormal).

What is abnormal about the load being higher than 1, especially on a machine with at least 4 CPUs?

> I have looked up v$seesion_wait, jobq slave waits obviously hold
> resources, that cause CPU loading is always high.
> Plz help to tune my system.
> Here is my machine load average.
>
> load averages: 2.19, 2.21, 2.21
> duck
> 10:55:52
> 90 processes: 86 sleeping, 1 stopped, 3 on cpu
> CPU states: % idle, % user, % kernel, % iowait, %
> swap
> Memory: 8.0G real, 5.5G free, 1.4G swap in use, 20.7G swap free
>
> PID USERNAME THR PR NCE SIZE RES STATE TIME FLTS CPU COMMAND
> 2155 root 1 10 0 45.5M 10.4M cpu01 656.7H 0 24.49% Xsun
> 1932 oracle 1 0 0 1.3G 1.3G cpu03 228.4H 0 16.40% oracle
> 1938 oracle 1 58 0 1.3G 1.3G sleep 151.8H 0 6.50% oracle
> 1936 oracle 1 58 0 1.3G 1.3G sleep 227.0H 0 0.09% oracle

Your Xsun process is taking more CPU than oracle does. Are you also using this machine to play Quake or Duke Nuke-em?

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB