From: przemolicc@poczta.fm
Date: Fri May 09 2003 - 05:57:59 EDT
Thanks to:
Torsten Huebler
Dirk Jansen
The solution is simple: there is no solution ;-)
Percentage in prstat comes from whole power of machine. So if the
server has 4 CPU and one process is fully utilizing one CPU
it uses 1/4 (25 %) of whole CPU power.
Thanks guys !
przemol
Original question below:
On Fri, May 09, 2003 at 11:06:16AM +0200, przemolicc@poczta.fm wrote:
> Hello,
>
> We are moving data between two different RDBMSes.
> My collegue is "importing" some data into oracle 8.1.7.
> It is not really import (in Oracles' terms) but rather
> moving data from one oracles' table (already imported)
> into other tables using transactions. Anyway,
> when he runs the process I can see following:
>
> PID USERNAME SIZE RSS STATE PRI NICE TIME CPU PROCESS/NLWP
> 10664 ora817 188M 170M cpu5 20 -10 2:36:19 25% oracle/1
> 59 root 6920K 6176K sleep 59 0 1:17:27 0.6% picld/12
> 304 root 42M 13M sleep 59 0 0:10:56 0.1% java/12
> 10796 root 5448K 4648K sleep 49 0 0:00:12 0.0% prstat/1
> 11133 root 4560K 4192K cpu0 59 0 0:00:00 0.0% prstat/1
> 323 root 2512K 1648K sleep 59 0 0:02:23 0.0% _upsd/1
> 10641 ora817 189M 165M sleep 59 0 0:00:30 0.0% oracle/11
>
> As you can see one process (10664) is using (only !) 25 % of CPU. It never
> goes above the level. Why solaris "blocks" it ?
> There isn't any job running on the server at the moment so it is safe
> to speed up the process. But how ? Is it possible ?
> I have changed priority of the process but it haven't helped.
>
> przemol
> _______________________________________________
> sunmanagers mailing list
> sunmanagers@sunmanagers.org
> http://www.sunmanagers.org/mailman/listinfo/sunmanagers
>
> ----------------------------------------------------------------------
> Handlowy portal INTERIA.PL >>> http://link.interia.pl/f171d
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:26:23 EDT