Re: cpu usage

>
> So i dont think the cpu time is an important factor and problematic on
> this server.
>
> What do you think?
>

I think your reasoning is good in the sense that it doesn't seem like your CPU's are busy. You could look at an operating system tool like sar -u to confirm that. Plus it doesn't seem like you have any poorly tuned SQL statements that are at the top of the list.

But the question is, is there a problem on your system? I.e. Do you have a user that is complaining about something running too long? If so then you need to look at where that user's Oracle session is spending its time as explained in Cary Millsap's book.

I think there is a debate among performance tuning experts about whether you should look at the system as a whole, like your statspack report, or look at the session of the program that is running too long.  I think that Cary Millsap's point on this is that looking at the overall statistics can be misleading.

But, given what you have shown us it appears that there isn't anything wrong with your system at all.

• Bobby