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/sunmanagersReceived on Fri May 9 06:00:39 2003
This archive was generated by hypermail 2.1.8 : Thu Mar 03 2016 - 06:43:10 EST