最耗CPU的进程
[root@test4 ~]# ps -e -o pcpu,pid,user,tty,args|sort -n -k 1 -r|head
95.4 19360 appldev ? frmweb webfile=5,8,test4_9095,/ebs10/oracle/prod/inst/apps/TEST4_test4/logs/ora/10.1.2/forms/socket.log
82.2 15911 appldev ? frmweb webfile=5,24,test4_9095,/ebs10/oracle/prod/inst/apps/TEST4_test4/logs/ora/10.1.2/forms/socket.log
23.0 28378 oradev ? oracleTEST4 (LOCAL=NO)
20.0 28380 oradev ? oracleTEST4 (LOCAL=NO)
17.0 28382 oradev ? oracleTEST4 (LOCAL=NO)
14.0 28384 oradev ? oracleTEST4 (LOCAL=NO)
2.6 28280 oradev ? oracleTEST4 (LOCAL=NO)
1.6 18861 oradev ? oracleTEST4 (LOCAL=NO)
1.2 15783 appldev ? /ebs10/oracle/prod/apps/tech_st/10.1.3/Apache/Apache/bin/httpd -d /ebs10/oracle/prod/apps/tech_st/10.1.3/Apache/Apache -DSSL -f /ebs10/oracle/prod/inst/apps/TEST4_test4/ora/10.1.3/Apache/Apache/conf/httpd.conf
0.9 4467 oradev ? /ebs10/oracle/prod/db/tech_st/11.1.0/bin/tnslsnr TEST4 -inherit
最耗内存的进程
[root@test4 ~]# ps -e -o pmem,pid,user,tty,args|sort -n -k 1 -r|head
9.3 19911 oradev ? oracleTEST4 (LOCAL=NO)
9.1 4401 oradev ? ora_smon_TEST4
8.7 4615 oradev ? ora_cjq0_TEST4
8.5 4435 oradev ? ora_q001_TEST4
8.4 21971 oradev ? oracleTEST4 (LOCAL=NO)
8.3 21959 oradev ? oracleTEST4 (LOCAL=NO)
8.0 21962 oradev ? oracleTEST4 (LOCAL=NO)
8.0 21946 oradev ? oracleTEST4 (LOCAL=NO)
7.8 4395 oradev ? ora_dbw0_TEST4
7.8 20066 oradev ? oracleTEST4 (LOCAL=NO)
取一个表名
[root@test4 ~]# alias topc='ps -e -o pcpu,pid,user,tty,args|sort -n -k 1 -r|head'
[root@test4 ~]# topc
放入到.bashrc文件中
[root@test4 ~]# vi .bashrc