Oracle clone renice still slow

From: Robert Threet (rthreet@usieagles.org)
Date: Wed Aug 30 2006 - 17:45:10 EDT


I have a V880 with 32MB of RAM, 8 processors and NO USERS. When we
clone an Oracle database is runs very slowly. Renicing both the
process and the user by -19 have no effect. It still sits at 93% idle.
 (BTW, i tried them one at a time before getting so many of them
reniced. It always stayed at 93% idle).

bash-2.05# renice -n -19 -u oracle
bash-2.05# renice -n -19 -p 5022

last pid: 5137; load averages: 0.38, 0.37, 0.38
16:43:23
71 processes: 70 sleeping, 1 on cpu
CPU states: 93.3% idle, 0.5% user, 5.3% kernel, 0.9% iowait, 0.0%
swap
Memory: 32G real, 27G free, 984M swap in use, 31G swap free

   PID USERNAME LWP PRI NICE SIZE RES STATE TIME CPU COMMAND
  5030 oracle 17 59 -20 366M 320M sleep 9:41 2.36% oracle
  5105 root 1 59 -19 2880K 1896K cpu/1 0:04 0.02% top
  5050 oracle 1 59 -20 2880K 1824K sleep 0:05 0.02% top
    66 root 12 59 0 7944K 6672K sleep 1:26 0.00% picld
  1605 oracle 11 59 -20 598M 541M sleep 3:13 0.00% oracle
   331 root 7 59 0 2536K 1384K sleep 2:15 0.00% mibiisa
  1607 oracle 1 59 -20 597M 546M sleep 0:21 0.00% oracle
  1601 oracle 258 59 -20 604M 546M sleep 0:05 0.00% oracle
  1603 oracle 11 59 -20 602M 541M sleep 0:04 0.00% oracle
  5022 oracle 1 59 -20 37M 24M sleep 0:01 0.00% rman
  1589 oracle 1 59 -20 18M 6816K sleep 0:01 0.00% tnslsnr
  4721 oracle 1 59 -20 5456K 2048K sleep 0:01 0.00% sshd
  1615 oracle 11 59 -20 601M 544M sleep 0:00 0.00% oracle
  1613 oracle 11 59 -20 601M 544M sleep 0:00 0.00% oracle

-------------------------
Robert Threet
http://linux.usi.edu/rat/
_______________________________________________
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:40:41 EDT