From: przemolicc@poczta.fm
Date: Fri May 09 2003 - 05:06:16 EDT
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
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:26:22 EDT