Oracle's performance on 4 CPU Server

Hello

Using Oracle 8.1.7 on a Sun E3500 (4 CPUs, 2 GB RAM), one application takes several days to finish and I am putting an eye on Oracle's performance. When I look to the graphs produced by the proctool, I don't really understand what is happening, because the CPUs are always to some extent "idle", which they shouldn't, since the "wait" times are near zero. To my understanding, wait times occur when the CPU is dealing with data contained in peripheric devices, otherwise CPU usage ("system" + "user") should approach 100%.

I am not even sure if Oracle is able to profit from several CPUs under Solaris 7.

How can I monitor what is the bottleneck in such a situation?

By the way, proctool is not an Oracle application, but just a free program to monitor CPU and HD usage and processes.

Thanks a lot

Rick

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net