Oracle process's running high CPU and CPU(nice)

[Charles Temple]

Hi, Not sure if it is normal for any oracle process that is running is running in NICE. So example is 98% CPU and 97% of it is NICE'D. How and why is this and should I change it to run normal. If I am suppose to change it how would I do that.
Model 8400 3 virutal partitions. Partition is question is running 6 875 cpu's. All cpus are pegged with 99-100% cpu usage and 98% is nice'd
Thanks,
Charlie

[twang]

Sometimes the CPU is fairly distributed across several processes. The only thing to do in that case is to try to see if they share a common task, like a the execution of a particular package or query. I would recommend that you take some statspack snapshots when the CPU is at it is peak and run some reports against the snapshots. From there, you can take a look at the top queries that are running that may be causing the CPU to spike and tune them using
the sql_trace and tkprof utilities mentioned above. Also, look at the buffer cache to see if the percentage is above 95% and increase the size if it is not. You can also search in the report for "table scans (long tables)" to see how many full table scans against large tables are occurring
at the time that the statspack report was taken.

[Charles Temple]

Thanks, I will do that. I am just wondering more about the CPU nice'd number. I thought the processes should run under the normal tag and if you want more/less priority then you nice them, I didn't think it always used nice.

THanks,
Charlie