solaris系统cpu利用率查询

sun029

# ps -eo pid,pcpu,args | sort +1n
该命令输出当前系统进程的pid, cpu占用率及命令描述，并以pcpu来排序

sun029

bash-2.03$ ps -eo pid,pcpu,args |sort +1n
    0  0.0 sched
    1  0.0 /etc/init -
    2  0.0 pageout
   62  0.0 /usr/lib/sysevent/syseventd
  170  0.0 /usr/sbin/inetd -s
  174  0.0 /usr/sbin/cron
  180  0.0 /usr/sbin/syslogd
  197  0.0 /usr/lib/utmpd
  230  0.0 /var/cfengine/bin/cfexecd
  234  0.0 /usr/lib/saf/sac -t 300
  235  0.0 /usr/lib/saf/ttymon -g -h -p sina6450 console login:  -t sun-color -d /dev/cons
  245  0.0 /usr/lib/saf/ttymon
  762  0.0 /usr/local/sbin/sshd
  pid %cpu command
23912  0.0 /usr/local/sbin/sshd
23914  0.0 /usr/local/sbin/sshd
23916  0.0 -sh
23922  0.0 bash
23935  0.0 ps -eo pid,pcpu,args
23936  0.0 sort +1n
    3  0.1 fsflush

sun029

CPU占用率高或许是Oracle本身编写的SQL的问题，涉及到数据库的调优，不知道你安装的是sol的哪个版本？如果是10，可以试试动态追踪DTrace功能。